Multiplying dynamic value


I am running a search for ‘flightLogs’. I want the search to return logs with date values within the last X days, where X is a positive integer number of days stored as a ‘PilotCurrency’. For example, below returns logs with departureTime > Current date/time + number of days.

CleanShot 2022-11-26 at 15.37.05@2x

I need to be able to search for current date/time - number of days, but I cannot seem to be able to find a way to multiply the dynamic PilotCurrency periodDays value by -1 to achieve this. What would you suggest?

Basically I need to do math with the dynamic value after the +(days) operator.

I assume you don’t have the parenthesis feature turned on in your app?…

If you do then it’s as simple as using current date/time: plus days: (dynamic number x -1)

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.