Multiplying dynamic value

[georgecollier]

Hi,

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.

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.

[adamhholmes]

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)