Trying to subtract one day from DateTimeToday

[cstafford]

I am trying to subtract one day from todays date (DateTimeToday) and not successful. I am using the formula tool to create two new date columns. One of which is labeled TODAY (DateTimeToday) and the second called YESTERDAY. However, I thought this formula would work but not having much luck

TODAY = DateTimeToday() 

YESTERDAY = [TODAY]<DateTimeAdd(ToDate(DateTimeNow()),-1,"days")

The output is ZERO.

[cstafford · Accepted solution]

Figured this out:

DateTimeAdd([TODAY],-1,"days")