A calculated filed called program date (a date field) is set to caculate based on the following;
I have a check box that has Yes or no as the possible choices. A calculation for dates is written as follows:
If(pre_nights = "yes"; departue date - pre-nights; departure date)
Pre_nights is a number field
Departure date is a date field
calcualtion is for a filed called program date
The field does not calculate. If the check box is "no" the field remains blank; if the check box is "yes" the field gives the departure date without the subtraction of the pre-nights.
Finally is there a way to force a record to re-calculate?
I would appreciate any ides on this.