Need lights with DateTimeAdd

[david20100]

I'm trying to get all data from (current run day of the workflow - 7 last days.) so will be able to generate reports for the supervisor to see how many hours have been worked last week

I use that formula in the filter tool: [End Date] >= DateTimeAdd(DateTimeToday(), -7, "days") and it gives me nothing.  Pretty sure i do something wrong.  Need your lights

thanks

[MarqueeCrew]

how about:

[End Date] >=
datetimetrim(DateTimeAdd(DateTimeToday(), -7, "days"),'days')

Does that work?

[david20100]

Nope still empty /  end date = Date Fin in my workflow

[MarqueeCrew · Accepted solution]

@david20100,

Your post didn't include data.  I've posted a workflow that includes the dates from 2017-02-23 through 2017-03-07 and used a copy of your filter (as-is) to select dates within the last seven (7) days. This is a picture of the results:

If you can post your data, you can OPTIONS->Export Workflow and post the yxzp (it will include data).

Cheers,

Mark

[david20100]

Here's the data

thanks