Date Validation

[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

 

[Rick B]

(<=date() and >[date started]) or null

 

[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.

(<=date() and >[date started]) or null

--
Rick B

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