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.