Calculate first and last day of the month

[jevans]

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]

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)