Alteryx Designer Desktop Discussions

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

Return last three days of data

Fred22
8 - Asteroid

Hi,

 

I need my workflow to return the last 3 days of data from the current date. Example: If today is March 19th I need to return all of the data from March 19th to March 16th.

 

Thank you!

3 REPLIES 3
jamielaird
14 - Magnetar

Hi @Fred22,

 

You can do this using a Filter tool setup as shown below, where [YourDate] is replaced with the relevant field in your dataset.

 

Last3Days.png

 

LordNeilLord
15 - Aurora

Hey @Fred22

 

Try in a filter:

 

[Date]>=DateTimeAdd(DateTimeToday(),-3,'days')

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Fred22
8 - Asteroid

Thank you!

Labels