Filtering Changing dates

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.

Workflow

Developer

Developer Tools

Date Time

Interface Tools

Accepted answers

OTrieger

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

u- "days"

All comments

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

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

u- "days"

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703