Problem with variant data type in calculated column

[Anonymous]

I am trying to use an if statement that uses a "fake" date when an order haven't been assigned a arrival date. 

But when writing this seemingly easy piece of code I get the below error message saying that it "can't return a variant data typ..."

There has to be a way around this. Does anyone know? 

Thanks in advance! 

[Anonymous]

Thanks for both answers! 

However I've tried that before and yes, the code works. But then I instead face the problem that Arival-date has the wrong data type. The end result is a column where I can change the type to Date (so that I can use a Date interval as a slicer).  

[daXtreme]

"2999-12-31" is a string, not a real date. Use the DATE function.

[Anonymous · Accepted solution]

Hi @Anonymous 
try using DATE(2999,12,31) in the second argument of IF() statement in place of "2999-12-31"