Limit date field to only allow current date or past dates

E

Eric

I would like to limit a data field in a table to only allow the current date
or past dates as we are tracking the date when something was completed...so I
want to limit the date so it does not allow future dates.
Thanks,
ERic
 
A

Arvin Meyer [MVP]

Eric said:
I would like to limit a data field in a table to only allow the current
date
or past dates as we are tracking the date when something was
completed...so I
want to limit the date so it does not allow future dates.
Thanks,
ERic
Click to expand...

Set a validation rule to:

<=Date()

Keep in mind that if done in a form, the date can be changed in a table. If
you set the rule in the table, you will have to deny validation any existing
dates, as the existing dates will not conform.
 
Top