today's date or previous

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

Guest

I want to make a form for a time registration. I would like make something so
he automatically takes the day of today (probably with "date ()" in default).
But it must also be possible to enter a previous date, without giving an
error.

How do I do this?
 
Would placing a validation for the field work? Something like
<Date()+1

Regards,
Nick
 
I want to make a form for a time registration. I would like make something so
he automatically takes the day of today (probably with "date ()" in default).
But it must also be possible to enter a previous date, without giving an
error.

How do I do this?

Well, it sounds like you gave the answer yourself. Simply set the
Default Value property of the textbox to =Date(). This will default to
today's date, and allow you to overtype that default with any desired
date.

You do say *time registration* - do you want just the date (with
midnight as the time portion) or do you want the current date and
time? If so use =Now() instead of =Date().

John W. Vinson[MVP]
 
I just need the date,
I Will work with quartes of an hour to indicate my time registration.

thanks for the help
 

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

Back
Top