This topic is locked

Default date - set to yesterday

10/26/2016 5:44:19 PM
PHPRunner General questions
S
Smithy author

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