I have a field that calculates the age on an invoice with the following calculation;

Ceiling((GetCurrentTimeStamp) - TimeStamp(Date_Sent; Time(0;1;0)))/86400)

Date_Sent is of type 'Date'. The formula works, but doesn't update from day to day. The only way I can get it to update, is to edit the calculation and change it back again, then it updates. Does anyone know why it's not doing this on it's own?

Thanks

Change the calculation to unstored. The value does not recalculate when it is stored.

May I ask whay you are using TimeStamp rather than Date?

Fantastic that worked, thanks

I'm using TimeStamp as it was in the example I saw. Is there a better way of doing it?

Get(CurrentDate) - Date_Sent.

Thanks transpower, that's even better. The otherone was rounding up, the Ceiling function I presume.