Hi, I'm trying to create a search where I can see when was the item last ordered on Amazon. The following formula is returning Invalid Expression but I can't figure out why, Field is Date Formula: CASE WHEN {transaction.entity} = 'Amazon' THEN {transaction.trandate} ELSE 0 END

0 is not a date

Great! I changed that to NULL and it worked Thanks a lot. I was wondering if there is a way to put if there is no date return something like 'never sold'