Workflow: Date Condition Routing
Summary: Hi experts, I want to create rules with Date conditions. Example: If the requisition was submitted in the month of January, route to approver A. If the month is not January, skip approver A and move to the next participant. We want to know if this is possible for year-end purposes. Currently, employees have to manually turn the rule on, plus they might forget. It would be beneficial if we could utilize Oracle's Date information.
Content: I am attempting to use the Calendar.MONTH function, but the approver hierarchy will not generate. After about a day of having the transaction status as 'In Progress' it fails, indicating the condition will not work. The function is looking for a numeric value, I tried 1 and 01 (January). I don't think the month value is in the workflow payload.