AnsweredAssumed Answered

Calculated field based on date error

Question asked by vpjohnston11 on Apr 29, 2009
Latest reply on Apr 29, 2009 by philmodjunk


Calculated field based on date error

Description of the issue

I have an issue with a calculated field that I can't work out, and wonder if it might be a bug? Here is my calculation: If (fin_tuitionProtParticipation = "Yes" and fin_dateRegFeePd > "2/27/2009" ; 275 ; 0) The calculation works for every date EXCEPT any date in the first 9 days of February. Anytime we have 2/1/2009 thru 2/9/2009 (anything with a single digit for the day of the month for FEBRUARY only), the result is 275 rather than zero. If I change the date to 2/10/2009 from any of the above dates, the result is correctly reported as zero. If I choose any single digit date in January 2009, the result is correctly reported as zero. Yes, I have confirmed that the first field (fin_tuitionProtParticipation) is set to Yes. As a matter of fact, I did a "Records/Replace field contents" to make sure. I have another calculated field based on the same fin_dateRegFeePd field that has the same problem...anything in the first nine days of February results in the wrong amount result.Hoping someone can explain or fix. File is hosted in FM Server 10 but am working locally in FMPro 9.0v3 on a Mac with OS 10.4.11