Last Day of Month

m17347047711116

Registered User.
Local time
Today, 14:13
Joined
Feb 4, 2002
Messages
68
In reading a post below i have learned how to make the default value of a field the first day of the month. Very handy thankyou
=DateSerial(Year(Date()),Month(date()), 1)

Question:
I would now like to learn how to make the other field on my form default value to be the last day of the month.

Thank you in advance for any help.
 
=DateSerial(Year(Date()), Month(Date()) + 1, 0)

HTH
RDH
 

Users who are viewing this thread

Back
Top Bottom