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

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

date difference.yxmd