How to make default Date "yesterday"?


#1

Hello. I am making a report on manufacturing of products made yesterday.
In the field Date, I can use $DATE as default to populate it on new records.
What if instead of today, I want it to be yesterday? I tried $DATE-1 and it becomes the year 2001.
Am I missing something?


#2

Hi,

The parameter of the Default value is not formulas, so you cannot use calculation operator.

If you’d like to populate value “today-1 (yesterday)” as default that it should not be recalculated
when the entry is edited afterward, please set up “interpret as formula” in your date field default value setting, and apply this default value formula “TODAYTZ()-1”.


#3

Thank you for the fast response, Amy.
Exactly what I needed. :smiley: