Set a date in a report that only pulls yesterday's date

steve50951 · 12/12/18

I have a report that I need to pull units from yesterday. When I set the date threshold as 1 day in the past it pulls units that are from today and yesterday. How do I set the date to only pull from yesterday's only?

thanks in advance for your help.

Paul Newcome · 12/13/18

You may need to use a helper column in the original sheet. For example, if you used a checkbox column named Yesterday, you could use the formula

=IF([Date Column Name]@row = TODAY(-1), 1)

This will check the box if the date is yesterday. You can then build your report by setting the criteria in the report builder as when Yesterday is checked.

steve50951 · 12/14/18

thanks!

Paul Newcome · 12/17/18

Happy to help.

Cindy Lamper · 04/14/20

How would I account for the weekend? For example "yesterday" on a Monday would actually be Friday. I need to see everything that came in "yesterday", but on Monday I need to see what came in on Friday.

Set a date in a report that only pulls yesterday's date

Comments

Categories