VALIDATE DATE TO ENTER ONLY THIS YEAR AND AFTER

[billquga]

Hello all! I have a table where i enter shipping information. in one of the fields [ACTUAL SHIP DATE](format is short date) I would like to make it so only a date that happened in or after the year 2002. is this possible? any help would be appreciated.

Thanks!

 

[RickSpr]

You could set the Validation Rule property to ">= DateSerial(Year(Date()), 1, 1)". That would allow any date in the current or a later year.

If you only want future dates, excluding earlier dates in the current year, use ">= Date()" instead.

Rick Sprague

 

[67peshawar294]

Billquga and Rick,
Wouldn't >#12/31/01# in the validation rule work as well?

 

[RickSpr]

Jpeneh10,
Yes, it would, taking what Billquga said literally. I inferred, perhaps incorrectly, that he was interested in limiting inputs to current and future dates, or at least dates in the current and future years. That seemed likely to me for a shipment date. Rick Sprague

 

[elizabeth]

Similarly to RcikSpr's idea, if wanting to make this more robust rather than just hard coding, you might add make the limit a certain amount of time aftersome other field, like an order date.