endOfMonth function

[tziviak]

Is there a function (as in microsoft excel) to check if a certain date is the last day of the month?
thank you

 

[GoDawgs]

Nothing specific...I've always used:

EOM: CDate(Month([DateField]) & "/1/" & Year([DateField]))-1

That's to show the EOM date...you can use it to compare to a date as well if needed. Hope that helps.

Kevin

 

[dhookom]

Substitute a field or variable name for DateExpression:
Month(DateExpression) <> Month(DateAdd(&quot;d&quot;,1,DateExpression))

Duane
MS Access MVP