I have an automation that I don’t want triggered on holidays or weekends. The weekends are easy to take care of with a cron expression, but for the specified holidays, it seems like the best way is to set up a custom non-working days calendar. Is there any way to identify the dates selected as a recurrence? For example, tell the calendar I want to exclude thanksgiving every year, or do I have to identify the dates for thanksgiving for the next 10+ years and manually select or upload them?
Hi @LaHood_AM
There is no possibility to mention the name of the festivals or occassions holidays. You have to mention the dates in the Non working days csv file. Then it will consider it has holiday.
Hope you understand!!
I went ahead and just identified the dates for the next 10 years and filled out the csv file. I used the “Download a sample CSV file” out of orchestrator and updated my dates, and did not change the date format at all, but when I try to upload it, I get an error saying that it’s in the incorrect date format. Any suggestions?
You have to give the date in MM/dd/yyyy format. After giving all dates select the format as below in the excel… @LaHood_AM
Hope it helps!!
That isn’t an option for a Date format for me for some reason. So I tried using custom formatting MM/dd/yyyy, which works initially. But if I save and try to upload, I get the same error. When I reopen the file, the formatting has reverted back to what’s shown below.
Don’t open the CSV file in Excel. Open it in Notepad, then add your dates.
You have given the different format dates, it should be MM/dd/yyyy format… @LaHood_AM
Give as below,
09/02/2024
11/28/2024
12/25/2024
01/01/2025
05/26/2025
07/04/2025
09/01/2025
11/27/2025
Hope you understand!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.