Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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