BeginDate and EndDate to return the 1st & last day of current mont

[Guest]

ACCESS 2000.
I have 2 unbound Fields in a Form, one is called BeginDate, and the other is
EndDate. When I open this form, I need the Default value to be (in short Date
Format) the first day of the month we are currently in, and the second, the
last day of the month we are currently in.

Plese Help!

(e-mail address removed)

 

[Guest]

For Begin Date, try setting the Default Value to
DateSerial(Year(Date()), Month(Date()),1)
and for End Date, try
DateSerial(Year(Date)), Month(Date()) + 1,0)

Hope This Helps
Gerald Stanley MCSD