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

[crouchsonia]

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

[MarqueeCrew · Accepted solution]

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

That just might work if you run the job daily.

Cheers,

Mark

[crouchsonia · Accepted solution]

Thank you very much that worked.