What Function would I use if I want to see if a fi...
# suiteanalyticsn
nathanw
08/11/2020, 10:39 PMWhat Function would I use if I want to see if a field is NULL and return a boolean?
I'm checking against a Custom Field I created of Type Date.
I considered using the NULLIF() but couldn't quite seem to get that to work.
nathanw
08/11/2020, 10:55 PMCASE
WHEN {custbody_expected_ship_date} != NULL THEN 0 ELSE 1
END
b
battk
08/11/2020, 10:56 PMbattk
08/11/2020, 10:57 PMthat said, no booleans in oracle sql
n
nathanw
08/11/2020, 11:55 PMFinal draft for any interested.
CASE
WHEN {custbody_expected_ship_date} IS NULL THEN 'No Exp. Ship Date'
ELSE 'Exp. Ship Date'
END
b
battk
08/11/2020, 11:57 PMNVL2({custbody_expected_ship_date}, 'Exp. Ship Date', 'No Exp. Ship Date')battk
08/11/2020, 11:59 PMyou could probably simply that further because the only difference between the two outputs is
'No '