Date Validation

K

Karen

Hi,

I need a validation rule for a field called "Date Completed". For this
field, the user can not enter a date greater than the current date, can not
enter a date less than the "Date Started" field, and the field can remain
null.

Thanks,
Karen
 
K

Karen

I used the code, but it won't let the user enter today's date in the "date
completed" field when the "date started" field is today's date as well. I
took out the =, but it still won't enter.

Rick B said:
(<=date() and >[date started]) or null

--
Rick B



Karen said:
Hi,

I need a validation rule for a field called "Date Completed". For this
field, the user can not enter a date greater than the current date, can not
enter a date less than the "Date Started" field, and the field can remain
null.

Thanks,
Karen
Click to expand...
Click to expand...
 
Top