Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Problem with variant data type in calculated column

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 sa...
  • Anonymous's avatar
    Anonymous
    4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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).