Filtering Changing dates

[sericson]

I need to create a workflow that filters for only the next weeks dates. so if I ran it today 08/29/24 I would need to filter for dates 09/03-09/06/24. is there a way to add this to the run screen in the server as it will need to selected each time it is ran. 

[OTrieger]

Hello @sericson

You can add a Date select to the user interface, however it is not needed if you will use Today as the based date.

You can add in a Formula tool Today() and it will be always taking the current date, then you can set with additional formula any future dates.
 

[Raj]

@sericson 
can you please elaborate on the requirement.

[sericson]

how would I set the formula for the changing future dates? 

[sericson]

Hello Raj, I need to be able to filter to only view the next weeks dates on a report. the original report contains dates for the entire year but I want to only view on week at a time. 

[OTrieger · Accepted solution]

DateTimeAdd(dt,i,u)
dt - Today date
i - how many days to add

u- "days"