Defaulting date field

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

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

Thanks

Regards
 
Hi John

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

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

Hope this helps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate Date for the first of the following month 0
Excel Vba to change displayed year automatically. 14
Default Value =Date$() in UK Date Format 5
Default date field 4
Default date does not save to the record 1
Current date and time default? 2
Excel How to get the number of days an item was opened from the today's date. 14
Date Picker Default? 1

Back
Top