In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filtering Changing dates

sericson
8 - Asteroid

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. 

5 REPLIES 5
OTrieger
13 - Pulsar

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
16 - Nebula

@sericson 
can you please elaborate on the requirement.

sericson
8 - Asteroid

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

sericson
8 - Asteroid

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
13 - Pulsar

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

u- "days"

Labels
Top Solution Authors