Syntax for filtering Dates older than from today
I'm trying to find the correct syntax for filtering based on dates older than 5 working days before today.
This is what I was envisioning, but it's a little off in regards to syntax.
workingdays(last(Chronos.'Date + Time')) + 5 < today()
Ninox is really good with days. The thing you have to watch out for is you have a date/time field so you have to convert it to date only data with the date() command.
I'm not sure where you got workingdays but there is a workdays() command. It would look something like this:
workdays(last(Chronos.date('Date + Time')),today())
This will return a number. If I remember your DB, this formula would appear in a parent record.
You mention filtering but I'm not sure what you want to filter. You can use it to filter a reference field like:
Chronos[workdays(date('Date + Time'),today())>=5]
Here we are filtering Chronos by using the workdays() command we ask Ninox to find the number of workdays between the date of the 'Date + Time' field and today and only keep the ones that return a number that is greater than or equal to 5 (dates older than 5 working days before today).
- Status Answered
- 3 mths agoLast active