AnsweredAssumed Answered

How to refresh Get(CurrentDate ) calculations?

Question asked by barnclos on Mar 1, 2018
Latest reply on Mar 1, 2018 by barnclos

Hello,

 

I'm just starting out on FMP, and amongst other things that are baffling me is an issue with a date calculation.

 

My app is used for tracking seed planting/germination etc. and has reminders for plants that need to be sown, or moved, at specified dates. I have a field "Sowing Target Date" and a calculated field "daysUntilPlanting" which is given by: If ( IsEmpty ( Sowing target date ) ; "" ; Sowing target date - Get(CurrentDate ) ).

 

My problem is that instances of the calculation are patently wrong. Today is 01/03/2018 (in European format), and the calculated values (daysUntilPlanting) in records 1, 2, 4 & 6 are all positive, despite the dates being in the past.

 

I re-entered the dates in records 3 & 5 (24/02/2018 & 25/02/2018) and this has produced a correct calculation.

 

I have just checked the later dates (09/05/2018 & 11/05/2018) and they are also 8 days out.

 

It seems that the Get(CurrentDate ) value needs to be 'refreshed' to update the calculations, but I can't find the way to do this.

 

Any help would be very welcome

 

 

Screen Shot 2018-03-01 at 16.19.24.png

Outcomes