Share
ReportI am trying to create a report that pulls information from the previous day. How do I create this filter? I know T=today. I was hoping T-1 would equal yesterday but it does not.
You’re offline. This is a read only version of the page.
10
I am trying to create a report that pulls information from the previous day. How do I create this filter? I know T=today. I was hoping T-1 would equal yesterday but it does not.
This worked. Thank you so much
Hi,
How are you setting the values for filter?
You can use (day(-1)) as a query range.
It's coming from SysQueryRangeUtil class, where you can see other useful methods and event add your own (if you can access code, of course).
Some documentation can be found under Advanced filtering and query syntax.
Hi Aaron you can use a value of today() - 1.
Were are you trying to set this filter?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (