AnsweredAssumed Answered

date calculations

Question asked by Jbmcglade on Dec 31, 2009
Latest reply on Jan 1, 2010 by comment_1


date calculations


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.