1 Reply Latest reply on Nov 18, 2014 12:06 PM by philmodjunk

    Problem with Date Calculation



      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?