How to use a conditional IF statement for a Calculated Date field?

1

On the Detail Create page, I have a Date field with a field code “start_date”.
When the page is initially loaded, the field is empty/blank.

I have a Calculated field “day1” with the formula “start_date + (606024*1)” which represents one day after the start_date.

Since the “start_date” is empty/blank when it is initially loaded, the “day1” is auto-filled with “Jan 5, 1970” which is the Javascript Epoch Time.

How to modify the formula so that when the page is initially loaded,
the “day1” is auto-filled with a blank?

1 Like
2

Hello annaylee,

If you want to make a Calculated field blank if a field used in the calculation field is blank, you should then use an IF statement something like the following :

IF(start_date = "", "", start_date + (606024*1))

2 Likes