Last day of the month

[jobb]

I need an expression that will produce the last day of the month..

for example, this year it would produce

2/29/04

next year it would produce

2/28/05

any help?

 

[Joe4]

Here is a calculation that will work. Given a date field name "MyDateField", it will return the last day in that month:

MyDate: DateSerial(Year([MyDateField]),Month([MyDateFiled])+1,0)

For the last day of the current month, you can make use of the Now() function:

MyDate: DateSerial(Year(Now()),Month(Now())+1,0)

 

[mdmilner]

For a VBA approach try:

http://www.mvps.org/access/datetime/date0007.htm

 

[jobb]

thanks, jmiskey and mdmilner! I'll try it later..