Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation Rule to not allow previous dates?

Status
Not open for further replies.
JaeBrett

JaeBrett

Programmer
May 5, 2003
196
CN
I have a field that is a date/time type in short date form. I want to have a validation rule when entering new data that the users can only enter datefor future dates.

How would I go about this?
 
Sort by date Sort by votes
Sorry, make that >Date().

Must remember to engage brain before clicking submit :)

John
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
387
SkipVought
S
ameedoo3000
  • Locked
  • Question
Send a message to an email
Replies
2
Views
2K
ameedoo3000
ameedoo3000
monkeysee
  • Locked
  • Question
Field to count specific records
Replies
3
Views
356
dhookom
dhookom
HebieBug
  • Locked
  • Question
Lookup field in a table will not allow me to use auto expand 1
Replies
2
Views
176
HebieBug
HebieBug
puforee
  • Locked
  • Question
Error when importing Excel with blank dates
Replies
4
Views
259
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top