Losing my brain... This case statement worked before the upgrade last week & now I'm getting ERROR: Invalid Expression... ??? CASE WHEN {fulfillingtransaction.trandate} < '04-01-2021' THEN 'Q1' ELSE 'Q2' END

2 things, first try it in suiteanalytics, it has a formula checker and tells you what is wrong with your formula second https://www.abaci-us.com/netsuite-to-date-to-char-date-functions/

Thanks. Frustrating that it worked before the upgrade. I have this same logic in a bunch of searches. The reminder about the dataset formula check is helpful. I added the TO_DATE and now its fine again.

dont rely on strings being properly changed to dates

Yep - lazy on my part. Thanks.