Hi team, I am trying to check a custom checkbox fi...
# general
k
Hi team, I am trying to check a custom checkbox field via Workflow when today's date is greater than due date field in the Invoice however the formula I am using not working. Per checking in the workflow logs it says Invalid Expression. Here's the formula I am using in the Workflow. CASE WHEN (TO_DATE({today}) - TO_DATE({duedate})) >= 45 THEN 'T' ELSE 'F' END Thank you!
m
CASE WHEN {today} >= {duedate} + 45 THEN 'T' ELSE 'F' END or {today} >= {duedate} + 45
k
Thank you, I will checking this.