Update all records with today's date

[mariaw]

Hi

I have a form that people have to fill in to report when someone is off sick.

The first notification they have is that the person is off sick - so they can only enter a start date on the form, and have to leave the end date blank

I want the end date to always be "today" - and to automatically update to "today" until an end date is entered by the user. To enter the end date, the user will go back to the original record where they put the start date in, and then enter the end date.

Any ideas... using date () will put today's date in, but then when I go in tomorrow, it will say yesterday's date...

Thanks!!!

 

[rborob]

use =Now() ?

 

[Rich]

You're better off leaving the end date Null and using the BeforeUpdate event of the form to warn users that the field hasn't been filled

 

[mariaw]

Thanks Rborob and Rich - I will see what happens when I log in tomorrow!

 

[ejstefl]

=Now() will just give you the date with time, you'll have the same problem.

I agree with Rich, there is little to no point in putting today's date in each day.