Data Validation: Historical date

[Jeff Polack]

I have a date picker on which I would like to ensure that the date entered is
not historical (i.e., before today). I've popped open the Data Validation
box, put in the name of the date picker control, entered 'is less than' in
the criteria and. . .

I can't figure out how to reference Today in the value box (i.e., DatePicked
< Today). Any assistance would be appreciated.

TIA

 

[Ramana Devi]

Hi,
Please follow the below steps for referencing Today in the value box
1. In Data validation box ,Put in the name of date picker control, enter ‘is
less than’ and select ‘Use a Formula’ from the third drop down
2. In Insert Formula box select ‘Insert Function’.
3. In Insert Function box select ‘Date and Time’ and select ‘Today’ from the
Functions list
4. Click Ok to close all the dialog boxes