`CASE WHEN trandate BETWEEN 2014 07 01 AND 2014 09 30 THEN a NetSuite Professionals #general

`CASE WHEN {trandate} BETWEEN '2014-07-01' AND '20...

Neil

11/29/2018, 3:01 PM

CASE WHEN {trandate} BETWEEN '2014-07-01' AND '2014-09-30' THEN {amount} ELSE 0 END

sam1128

11/29/2018, 3:03 PM

Why do t you you date criteria rather then in formula.

Neil

11/29/2018, 3:04 PM

using criteria but need to separate them for columns

18 Views