Get (CurrentDate) function not working properly.

[HX_Guy]

I have a calculation setup that gives an aging amount based on current date and date entered for when the contract was signed.

I swear it used to work ok but for some reason it no longer does, the number of days is off vs what it really should be. As can been seen in the screenshot examples taken just now (11/03/15), the Days Old shows 19 days when in reality its been 34 days since 10/01/15.

Any ideas why this wouldn't be working? Seems like a pretty straight forward calculation.

 

 

Ok so I did a test of deleting the "Contract Signed" field and the Aging when to "blank" as it should, then I added the date of 10/01/15 back in and it updated with the correct date. 

So it seems that it's not updating on a daily basis? Am I missing something in the calculation to have it auto refresh every day?

Edited November 4, 2015 by HX_Guy

[webko]

Have you set the calculation to Unstored?

If it's stored, it will only update when one of it's feeder pieces of data changes (as happened when you re-entered the Contract Signed date)

[HX_Guy]

Thanks for the quick reply webko.

I don't believe I have set it to Unstored - how would I go about doing that?

Would it be one of these options? 

webko it looks like that was it! I check off "Do not store calculation results" and results across all records updated instantly. I assume tomorrow they will auto update?

Thanks again for the help.

[comment]

9 minutes ago, HX_Guy said:

Would it be one of these options? 

Yes. Check the "Do not store ..." box.