Hello!
I have a case when statement that I need to subtract a certain amount of days based off of:
Case
when 'ID' = '1066' THEN `Maturity Date` - 45
when 'ID' = '1019' THEN `Maturity Date` - 55
when 'ID' = '2600' THEN `Maturity Date` - 66
when 'ID' = '2507' THEN `Maturity Date` - 70
when 'ID' = '1075' THEN `Maturity Date` - 75
when 'ID' = '2669' THEN `Maturity Date` - 85
ELSE `Maturity Date` - 60
END
This comes back as an error as it's trying to have the output be a floating decimal instead of a date.
Any assistance is greatly appreciated. (I'm still fairly new to using Domo)