Filter Function - Dynamic Date Range

[ahernandez39]

Hey Everyone! 

I am new to using Alteryx so any help would be appreciated! Currently we have a workflow that has the "Filter" tool to capture travel dates and remove the ones not needed. The date range is dynamic and we currently are using the script below. 

[Planned Departure Date & Time] >=DateTimeNow() AND [Planned Departure Date & Time]<=DateTimeAdd(DateTimeNow(),7,"days")

This script targets Planned Departure Date & Time for the seven days in the future when the workflow is run. What i need is to add something that will also capture "today's date". For example when i ran the workflow this morning it capture dates 2/19-2/25. I need it to capture dates 2/18-2/25. does anyone have any advice on what to change on the script?

Thank you in advance! 

[Jonathan-Sherman · Accepted solution]

Hi @ahernandez39,

Could you try wrapping your DateTimeNow() function in a ToDate() function:

[Planned Departure Date & Time] >= ToDate(DateTimeNow()) AND [Planned Departure Date & Time]<=DateTimeAdd(DateTimeNow(),7,"days")

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[ahernandez39]

I just tried it and it worked! thank you so much @Jonathan-Sherman