Forum Discussion
Solved
If Then Else to calculate a date
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 r...
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/This worked great. Thank you as overthinking got me once again. Thank you again.
As tackytechtom said, but you should use the syntax
if [Date] = null
instead of
if [Date] is null
--Nate
Sorry, this didn't work. Thank you for your time.