Add "workdays" as a date-based wildcard | Community
Skip to main content
Level 4
Apr 25, 2018 11:12 PM UTC
New

Add "workdays" as a date-based wildcard

The date-based wildcards that are currently available are ‚Äòq’, ‚Äòh’, ‚Äòd’, ‚Äòw’, ‚Äòm’, and ‚Äòy’ for calendar quarter, hour, day, week, month, year respectively. “d” refers to calendar day.

We have a number of reports that filter for items created in the last 24 hours; unfortunately, we need another version that filters for the last 72 hours that our teams use on Mondays (so that they can see Friday results).

There should be a wildcard for workday, so if you filter for

entryDate=$$TODAY-1d

you can get Friday results on Monday, not Sunday results.