Default 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
 
R

Rick Brandt

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

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

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

Top