Avatar

Level 3

What I want is to enter a date in a date/time field and if there is a holiday I want it to display in another field on the same page.  However, there are 7 pages to the form and each page has a date/time field and a field to display the holiday.  On pages 2 – 7 the date/time fields is calculated from the StartDate on page one.

The way it works is if the StartDate is say tomorrows date Wednesday August 31st, 2011 the next page will display Thursday September 1st, 2011 and the next page Friday September 2nd 2011 and so on.  If a holiday is on one of those dates it will appear below the date/time field.  If there is no holiday nothing appears.

I have it on the exit of the StartDate field on the first page but will not work if I have it on the exit of date/time fields on the other pages I’m assuming because these are calculated.  So I put it in the validate area which works but throws up the error for each field.  See my post above for the error. 

I wish there was a way to upload the form.