1 of 1 people found this helpful
Here's a different method leveraging a boolean. This just returns "True" if the date falls within the window you're looking for. Just add it as a filter and select "True".
IF [Order Date] <= DATEADD('day',-1,TODAY())
AND [Order Date] >= DATEADD('day',-31,TODAY())
Hi Hari / Wesley,
Thank you for your help on this query. I really appreciate it. Both solutions give me what I wanted.
You are welcome.