Hello,
I am trying to set the default value for a date field to yesterday's date.
I have tried:
now()-1
date("dmy",strtotime("-1 days"))
date("dmy",strtotime("-1 day"))
date("dmy",strtotime("-24 hours"))
in the "Edit As" section of the editor for the date field.
Is there a formula / function I can use to simply default to yesterday's date without trying to set it at a database level ?
Thanks in advance for your assistance.
Regards
Craig