Last day of current month? 3

[Yerdon]

Hi Everyone,

I know this has to be easy - but I can't figure it out. I want the last day of the current month. Basically, the counterpart to: Minimum(MonthToDate), which returns the first day of the month.

If I use Maximum(MonthToDate) it returns the current date.

Help!!!

Thanks,

Joseph

 

[lbass]

Try:

dateadd("m",1,currentdate-day(currentdate))

-LB

 

[bdreed35]

There are several variations.
Here is one:

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

~Brian

 

[bdreed35]

I think LB meant:

dateadd("m",1,currentdate)-day(currentdate)

The other version will not return the correct month end date when the previous month has less days then the current month


~Brian

 

[Yerdon]

Thanks!

That worked!

Joseph

 

[synapsevampire]

Or...

dateserial(year(currentdate),month(currentdate)+1,1)-1

The dateserial is a nice function to keep in mind for most date work as it always adjusts correctly.

The previous post works fine, just offering up alternatives, and once you understand the basic premise of dateserial, most date functions are very simple.

-k

 

[lbass]

Thanks, Brian, for the fix. It wouldn't have worked right without it.

-LB