First and Last Day Of Month

[shakti5385]

Here is another LINK that finds the number of days in a month

I thought they want the formula in the CR not in the VB.

[Mark Gambo]

I thought they want the formula in the CR not in the VB.

Hmmm, maybe so but with the examples I supplied the op should be able to create the CR Formula.

[Mark Gambo]

But here is the CR Formula:

DateAdd("m",1,DateSerial(Year({Table1.dtDate}), Month({Table1.dtDate}),1))-1

@ Shakti - Looks like my code in post #3 except without the Variable.

[Mark Gambo]

Here are a few other links I found:

http://www.tek-tips.com/faqs.cfm?fid=1960
http://www.crystalreportsbook.com/Cr...I.asp?Page=7_3

[shakti5385]

But here is the CR Formula:

DateAdd("m",1,DateSerial(Year({Table1.dtDate}), Month({Table1.dtDate}),1))-1

@ Shakti - Looks like my code in post #3 except without the Variable.

This is also not giving the result, In CR it dispalying the Date only not the last day of Month.