How to find prior day

[Rob_schneider]

Is there a way to Find the day prior to today using DATETIMENOW() ?

[patrick_digan · Accepted solution]

@Rob_schneider You can try this one in a formula tool:

DateTimeAdd(DateTimeNow(),-1,"days")

If you save the field as a Date, it would be something like "2017-05-09". If you save the field as a datetime, it would have the current time added as well.