I'm trying ```CASE WHEN {createddate} BETWEEN to_d...
# suitescriptj
james_lloyd
06/26/2017, 7:04 PMI'm trying
Copy code
CASE WHEN {createddate} BETWEEN to_date(TRUNC(TRUNC({today}, 'MONTH')-1,'MONTH'), 'MM/DD/YYYY') AND to_date(TRUNC({today}, 'MONTH'), 'MM/DD/YYYY') THEN {internalid} ELSE 0 END