community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

How to get yesterday's date in a Formula to Filter Data

Meteoroid

I am looking for a formula to filter my data as of yesterday.  Basically a workflow will be scheduled that runs each morning to create a file with yesterday's credit information in it.  I want to filter based on the field Credit Date.  I assume I would use the Filter Tool.  The Credit Date field is formatted like yyyy-mm-dd

Alteryx Certified Partner
Alteryx Certified Partner
DateTimeAdd([credit date],1,"days") =datetimetrim(datetimestart(),"day")

That just might work if you run the job daily.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Meteoroid

Thank you very much that worked.  

Labels