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?
The calculation field must be an unstored calculation field or it will not update as the current date changes. It cannot be an auto-entered calculation either.