Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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
Top Solution Authors