AnsweredAssumed Answered

How to use Null In Formula Builder With Date

Question asked by James West on Sep 19, 2018
Latest reply on Nov 26, 2018 by Aaron Kerr

I have 3 fields. One is a date. ($report_due_c)

Another is a number of days for extensions. ($exntionnew_c)

Last is one that adds the extension to that date. (Due Date) Within it, using the formula builder of an On Demand Latest version of Sugar, I have this formula: addDays($report_due_c,number($exntionnew_c))

If no date is in report_due_c, all fields show blank in sugar, as expected. If there is a date all works as expected.

 

My problem is that in reports, there is a date if its intended to be blank: 11/30/-0001

 

The formula builder isnt allowing me to do what I think the formula may be. Any help would be appreciated. I want to have the date show blank in reports without 11/30/-0001.

 

Iv tried this:
ifElse(equal($report_due_c, ""), null, addDays($report_due_c,number($exntionnew_c)))

So If field is blank, be null. Otherwise add days. Iv tried quotes too.

 

Any suggestions?

Outcomes