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

I don’t think you need the case when statement Just use the (TO_DATE({today}) - TO_DATE({duedate})) >= 45 part

Thank you, I will try this.