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
Solved! Go to Solution.
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 : )
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