Validation - Prevent Date Which is < Today

[07sanchez]

Hi all,

Looked everywhere and can't find this at all.

All I want to do is put on a validation rule which prevents a date being entered which is before today. I have tried several things but nothing works.

am I being thick (You can be honest)

Thanks

 

[toad848]

Hi all,

Looked everywhere and can't find this at all.

All I want to do is put on a validation rule which prevents a date being entered which is before today. I have tried several things but nothing works.

am I being thick (You can be honest)

Thanks

Use

>=Date()

as the validation rule.

 

[pbaldy]

Have you tried:

>=Date()

 

[boblarson]

The simplest is in the VALIDATION RULE on the field in the table. The syntax would be

>=Date()

Then you can add text in the Validation Text. Now, from a practical perspective, you should use forms to have user input and then handle the validation there before it tries to save to the table. It will save your users a bit of pain instead of getting to the end and they can't save because the validation fails. It would be better if, when they go to enter the date that it squawks at them at that time.

 

[07sanchez]

Thanks everyone

I tried all those with no luck.

Eventually I got >= now() working