I have several searches that use case statements a...
# suiteanalytics
c
I have several searches that use case statements as formulas, and they've broken since I created them last week. They worked fine on Friday, but not today. SQL is not my strong suit, so maybe Im doing something wrong? As a test, i created a transaction search with no criteria, and one formula field column. The formula is 'CASE WHEN {trandate} BETWEEN '12/31/2023' AND '03/30/2024' THEN {amount} ELSE 0 END' When setting this columns summary type to sum, i get an invalid expression error for that column. Removing the summary type causes an "unexpected error." Am i doing something wrong, or do i need to open a support case? Using TO_DATE() on the dates also returns an error.