Date and time settings
Date and time settings
Defines the global calendar settings that will be used by other actions of the Date and Time group. It allows you to load a list of holidays — from a CSV file or a manual list — and to define which days of the week must always be considered non-working days. Actions such as Add Date, Remove Date and Check Holiday can reference these settings to take holidays into account in their calculations.
Options
Load holidays from
Defines the source of the list of holidays. The available options are:
- Do not load — no holiday will be configured
- CSV — the holidays will be read from a CSV file at the path provided
- List — the holidays will be provided manually as a list of dates
CSV file path
Enter the full path of the CSV file that contains the holiday dates. This field is only shown when the CSV option is selected.
Holiday dates
Enter the holiday dates separated by the delimiter provided. This field is only shown when the List option is selected.
Delimiter
Enter the character that separates the dates in the CSV file or in the list provided. The default is semicolon (;). This field is shown when the source is not Do not load.
Input format
Defines how the date format will be provided. This field is shown when the source is not Do not load. The available options are:
- Common value — choose the format from a list of predefined formats (default)
- Manual value — type the format manually
Date format
Select the format of the dates in the CSV file or in the list. This field is shown when Input format is Common value. The available options are:
- Traditional — 31/12/2026
- In full — 31 de dezembro de 2026
- International — 2026-12-31
Date format (manual)
Type the format of the dates in the CSV file or in the list, for example DD/MM/YYYY. This field is shown when Input format is Manual value.
Weekly holidays
Select the days of the week that must always be treated as a holiday, regardless of the list of dates. For example: Saturday and Sunday for environments that only work on business days.
Returns
This action has no direct returns. The ID of this action is used as a reference by the other actions of the Date and Time group that need to take holidays into account in their calculations.
Rules and Conditions
- When the source is CSV, the file path is required. If the file does not exist, the action raises an error.
- When the source is List, the dates must be separated exactly by the delimiter provided.
- Dates that do not match the configured date format are ignored.
- The weekly holidays are always applied, regardless of any list of dates loaded.
- This action must be executed before the actions that reference it.