Peter Bertelsen
11/06/2019, 2:02 PM["formulanumeric: CASE WHEN TO_DATE({custrecord_absence_employee.custrecord_absence_enddate}, 'dd/mm/yyyy') = TO_DATE(TRUNC(CURRENT_DATE-1), 'dd/mm/yyyy') THEN 1 ELSE 0 END","equalto","1"]
Zack
11/06/2019, 2:49 PMvar formula = [
String("formulanumeric: CASE WHEN TO_DATE({custrecord_absence_employee.custrecord_absence_enddate}, 'dd/mm/yyyy') = TO_DATE(TRUNC(CURRENT_DATE-1), 'dd/mm/yyyy') THEN 1 ELSE 0 END"),
"equalto",
"1"
];
Peter Bertelsen
11/07/2019, 6:24 AM