Default date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two unbound text boxes on a form that I use for "beginning date" and
"ending date". I have the "ending date" set for the current date as the
default. I would like to be able to set the default date for the "beginning
date" as 01/01/current year. Is this possible? These dates are used to fill
parameters for a query.

Thanks
 
Mark said:
I have two unbound text boxes on a form that I use for "beginning
date" and "ending date". I have the "ending date" set for the
current date as the default. I would like to be able to set the
default date for the "beginning date" as 01/01/current year. Is this
possible? These dates are used to fill parameters for a query.

Thanks
Click to expand...

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