Limit date field to only allow current date or past dates

[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

 

[Arvin Meyer [MVP]]

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

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.