Defaulting date field

J

John

Hi

How can I default a date field to the first of the current month and year?

Thanks

Regards
 
W

Wayne-I-M

Hi John

Use for year
=DateSerial(Year(Date())+0,1,1)

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

Hope this helps
 
Top