If Then Else to calculate a date

[dferry]

I am trying to calculate a date by using two date columns.  I want to use column  mos_d_override first but if there is a null value then i want to use mos_d_schedule.  I get results but not correct results.  The results of this formula are used in another formula to calculate past due days.  I  am new to this so please bear with me.  Thank you.

if [mos_d_override] is null then Date.AddDays([d_schedule] else Date.AddDays([mos_d_override]

[tackytechtom · Accepted solution]

Hi @dferry ,

How about this?

if [mos_d_override] is null then [d_schedule] else [mos_d_override]

Let me know, if this solves your issue 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Anonymous]

As @tackytechtom said, but you should use the syntax

if [Date] = null

instead of

if [Date] is null

--Nate

[dferry]

Sorry, this didn't work.  Thank you for your time.

[tackytechtom · Accepted solution]

Hi @dferry ,

How about this?

if [mos_d_override] is null then [d_schedule] else [mos_d_override]

Let me know, if this solves your issue 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[dferry · Accepted solution]

This worked great.  Thank you as overthinking got me once again.  Thank you again.