Date now -7

[Plewis1]

I have a workflow that runs once a week. The data appends to a excel sheet and stacks itself. I am trying get the filter tool to run that day the data is pulled plus 7 days back every week. Any help would be appreciated. Also I don't have any time in the column, so do I also need to build the formula in a way that excludes time? 

Thank you

[Phill]

@RolandSchubert your comments here where really useful. I'm doing the same thing but I notice the filter is including today, do you know how I can exclude it?

Thanks

[RolandSchubert]

Hi @Phill ,

I think, you could add a second condition to the filter statement to exclude today, it would look like this:

[Date] >= DateTimeAdd(DateTimeToday(), -7, "days")
AND
[Date] < DateTimeToday()

The first part selects all days starting last week, the second part limits it to all days before today.

Does that help?

Best,

Roland