Get a specific Range of Dates

[fitch1892]

I have a [date] column and I want to identify all the [date]'s and their values that are 30 days prior to today. How would I do this? 

For instance, since today is 10/18 I want to identify the values in [date] as 09/18, 09/02, 08/09. And not date values such as 10/09 or 10/02. 

date    |  value

09-18      A

09-02      B

10-10      C

[acarter881 · Accepted solution]

Hello @fitch1892.

Please see the attached workflow.

I believe this is what you're looking for. It can be done dynamically within a Filter tool. If the dates aren't formatted as dates, then they need to be transformed to dates before comparing.

Spoiler

[binu_acs]

@fitch1892 One way of doing this with the filter tool

[fitch1892]

This worked great! Thank you! I did something similar to this prior to this question but i was missing the "DateTimeToday()" .