View Full Version : Calculate first and last day of the month


jevans
03-03-2001, 07:55 AM
I have a form with to fields "Begindate" and "Enddate". I would like to have these fields on form open generate the first and last days of the current month automatically.

Thank you, in advance!
Jerry

Jack Cowley
03-03-2001, 08:13 AM
This will give you the first day of the current month:

=DateSerial(Year(Date()),Month(Date()),1)

and this the last day:

=DateSerial(Year(Date()),Month(Date())+1,0)