Default Date in Textbox

[JPR]

Hello,

I would like to add two unbound text boxes on a form which indicate the 1st day of the current year (txtFrom) and the current date (txtTo).

Thank you for your help.

 

[theDBguy]

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

 

[Papa_Bear1]

You probably already know this - but - if you also want to have control over exactly how the date appears - you could use the Format() command along with those Date functions to yield very specific results. (If you needed YYYY-MM-DD for example, you could use: Format(Date(),"YYYY-MM-DD"), that kind of thing.)