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.
