Filter Dates to Only See Yesterday's Values

(0) Share

Report

Posted on by Aaron Butler23

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.

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi Aaron you can use a value of today() - 1.

Were are you trying to set this filter?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
vinitgoyal2005 6,332 on at

Like (0)

Report

Hi,

How are you setting the values for filter?

Was this reply helpful? Yes No
Aaron Butler23 10 on at

Like (0)

Report

This worked. Thank you so much

Was this reply helpful? Yes No