AnsweredAssumed Answered

date calculations

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

Title

date calculations

Post

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.

 

 

Thanks,

 

John 

Outcomes