date picker validation

A

abrown

I have 2 date fields on my form (Request Date and Due Date). I'd like to add
a validation to the Due Date field, so that people can not enter a date
within 7 days of the Request Date. How can this be accomplished?
For example, if someone enters a Request Date of 12/11/2008 I want them to
be required to enter a date of 12/18/2008 or greater.
 
S

Swathi (GGK Tech)

Hi,
Add a data validation to the Due Date by following the below steps.
1.Go to Due Date properties.
2.Click Data validation button.
3.Click Add button.
4.Select Due date field in first drop down, is less than in second drop
down, Use formula in third drop down.
5.Click Insert function then select addDays() function by selecting the
Request Date as the first parameter and 7 as second parameter. Click ok.
6.Then select and in the fourth drop down.
7.Select Due Date in the first drop down of second row, is not blank in
second drop down.
8.Write the screen tip for the user and then click ok.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top