Formula for finding last date returns correct value when testing inside expression builder, but wrong value in the App itself
In my Risk Analysis App, user inserts a risk and then can insert several analysis.
each time user inserts a new analysis, it records the time the new analysis was registered or edited and the date for the new analysis (based on a number of days user inserts + analysis creation date)
They are shown correctly on their own register.
However, when returning to the Risk Register Screen, it should show the last Analysis Creation Date and the date for the next Analysis.
I am using the formula max(select(xxxx)
When I test the formula, it returns me the correct dates… for example… next analysis in 16/05/18, based on last analysis insertion date + 30 days.
I save, go to the app, run the app, what do I find on the Next Analysis? Today’s date.
PS: yup, I DID delete the initial value “today()”.