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 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'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"

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

  • daXtreme's avatar
    daXtreme
    Solution Sage
    4 years ago

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

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