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

@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

DateTimeHelp.yxmd