Last Day of Month 1

[chrisppppp]

Hi

I've created the following formula to calculate the last day of the month 2 months ago in date format:

DateAdd("m",1,DateSerial((Year(currentdate)), (Month(currentdate)-2),1))-1

However it returns in DateTime format, how can i rejig this formula so it is only in date format?

 

[IanWaterman]

In crystal just format it as date in the display, your default format is probably set as datetime.

Failing that

date(DateAdd("m",1,DateSerial((Year(currentdate)), (Month(currentdate)-2),1))-1)

But there is no reason to do this

Ian

 

[bdreed35]

You could also use this formula:

dateadd("m",-1,minimum(monthtodate))-1

~Brian