Calculate Age of Invoice

[nutthick]

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

[RalphL]

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?

[nutthick]

Fantastic that worked, thanks

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

[transpower]

Get(CurrentDate) - Date_Sent.

[nutthick]

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