Pull last 120 days of data

[tf05]

I am looking to pull the last 120 days of data from whatever day the workflow is run (today's date).

The data field is inputting in a DateTime format

Can anyone please outline the flow for that?

Thanks

[atcodedog05]

Hi @tf05 

Here is how you can do it. I am checking is the difference between today and the date is less than or equal to 120.

Workflow:

Hope this helps : )

[EKBS83 · Accepted solution]

Hi tf05,

You should be able to use a filter tool and write an expression in the Custom Filter section:

[your date field]>=DateTimeAdd(DateTimeToday(),-120,"days")

This will return all the data within these parameters to the "T" output.

Hope this helps

Thanks

Ed