Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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