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