Date Range Tool Help

[czjames87]

Is there a tool that allows me to pull data from the previous week? For example if i run my flow on Monday 9/26 is there a tool that will allow me to see only the data from 9/19 -9/23 but allow me to run it weekly without having to manually update the data range?  I am running an automated report but need to see the previous weeks data on a set schedule when i run the flow every week. I am currently using the filter tool but it only allows me to pull data from the current day back a week. Any help would be greatly appreciated. Below is what I am using. 

[Felipe_Ribeir0 · Accepted solution]

Hi @czjames87 

Please take a look at the attached workflow. You can use the DateTimeFormat function to get the current week, and subtract 1 to get the last week.

After that, use the same function to get the weeks of your dataset, and make the weeks of your data set equal last week.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.