Hi Experts,
I’m trying to 10 business to the certification deadline through workflow… Is there an option available add calculate how many “SAT/ SUN” in between 2 dates, So that i can subtract those to have actual business days.
Could you help me in this. If we can achieve this through custom workflow.
There isn’t any easy way to do this in workflows. The Define Variable can help you to some extent but won’t get exact results as needed.
It requires some calculations and date formatting which may be better suited for a transform/rule.
If i write a transform to calculate the actual business days, Do we have option to use that transform in workflow?
You cannot use it directly. You will have to map it to an identity attribute and then use that attribute from Get Identity action response to set the date. But passing cert start date as input date to your transform is something challenging unless you want to base it on now() and then the date in that attribute will always be 10 business days after today and you can use it readily.
Another option/workaround could be using Forms, you send a form to Cert Admin and they can select the due date of certification. You can then use the formData to set in your workflow. The drawback here is the manual intervention. The workflow won’t proceed until the form is submitted.
1 Like
Another effective solution is to create a custom HTTP endpoint using Azure Functions (for Azure platform) or Lambda scripts (for AWS platform). By doing so, you can trigger the function by sending an HTTP request with the required date provided in the request body. The function will then process the date and return the necessary date that needs to be used, addressing your specific requirement. Utilizing the HTTP Action in this scenario allows you to easily achieve your objective.
1 Like
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.