AnsweredAssumed Answered

Problem with Date Calculation

Question asked by eekamouse on Nov 18, 2014
Latest reply on Nov 18, 2014 by philmodjunk


Problem with Date Calculation


I am importing records with a "sale_date" formatted as yyyy-mm-dd

I have a calculation field as follows to tell me when it is possible to bill these sales records 

If (Get(CurrentDate) >Sale_Date+25; "ready";""


Problem is that when I import the data the calculation doesn't display as it should (remains empty)

If I cut the value out and paste it back into "sale_date" the calc works. Same thing happens if I change the +25 to +2 in the calculation definition. Then when I set it back to +25 it works.

Am I missing something?