Can anyone help me with this case statement? I hav...
# suiteanalytics
c
Can anyone help me with this case statement? I have two date/time fields and I'm trying to highlight if the two fields are on the same date. Because these two fields are date/time i feel like i have to use the TO_DATE function 'CASE WHEN TO_DATE({custbody_loe_requested_date}, 'mm/dd/yyyy') = TO_DATE({custbody_sow_req_date}, 'mm/dd/yyyy') THEN '1' ELSE '0' END'