Need help with a reporting date formula that can possibly includes 2 blank dates

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Trying to make a report field that looks into Actual Date first.  If Actual Date is blank, it will look into Forecast Date.  If Forecast date is blank, look into Formula Date.  I was originally thinking using NZ() but it only works with 2 variables.  My logic should be something like 

Report Date

 if([Actual Date] =""), [Forecast Date]

 else if([Forecast Date] = "", [Formula Date])

So in priority, checks Actual, if Actual blank, use Forecast, if Forecast blank, use formula.  Just not so sure how to put that into logic formula that quickbase can use.  Any help is appreciated.

Photo of Yang

Yang

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of dwhawe

dwhawe, Champion

  • 908 Points 500 badge 2x thumb
With dates you test for null rather than "".

It would be like this although it is untested.


If(IsNull([Actual Date]),If(IsNull([Forecast Date]),[Formula Date],[Forecast Date]),[Actual Date])
I think this is simpler

IF(
not IsNull([Actual Date]), [Actual Date],
not IsNull([Forecast Date]),[ForecastDate],
[Formula Date])
Photo of Yang

Yang

  • 0 Points
ah, didn't know about the null for dates.  Thanks.