Difference between revisions of "Holiday Calendar"
From SmartWiki
(→Setting the Holiday Calendar) |
|||
| Line 6: | Line 6: | ||
# In [[Global Settings]], under the [[Business & System Configuration]] header, select the calendar you have created from the drop-down box. | # In [[Global Settings]], under the [[Business & System Configuration]] header, select the calendar you have created from the drop-down box. | ||
:[[Image:HolidayCalendar.png|link=]] | :[[Image:HolidayCalendar.png|link=]] | ||
| + | |||
| + | The following formulas, which will take into account the holidays you have configured, can now be used: | ||
| + | * Adding business days to a given date: '''SS_FUNC.addbusdays(''DATE'', ''BUSINESSDAYS'')''' | ||
| + | * Counting the number of business days between two dates: '''SS_FUNC.countbusdays(''FIRSTDATE'', ''SECONDDATE'')''' | ||
==Holiday Calendars in Workflows== | ==Holiday Calendars in Workflows== | ||
Revision as of 14:19, 29 August 2013
The Holiday Calendar is a SmartSimple calendar that stores dates designated by your organization as holidays. It can be used in conjunction with formulas to perform calculations on and adjust date fields so that your organization's holidays are taken into account when a certain number of business days are added or subtracted from a date.
Setting the Holiday Calendar
- Create a new Calendar
- Create Events in the Calendar with the Event Type of "Holiday" on the dates you wish to indicate as statutory holidays.
- In Global Settings, under the Business & System Configuration header, select the calendar you have created from the drop-down box.
The following formulas, which will take into account the holidays you have configured, can now be used:
- Adding business days to a given date: SS_FUNC.addbusdays(DATE, BUSINESSDAYS)
- Counting the number of business days between two dates: SS_FUNC.countbusdays(FIRSTDATE, SECONDDATE)
Holiday Calendars in Workflows
Holiday Calendars can also be specified on Workflows. The setting to choose a specific Holiday Calendar to be used for a given Workflow is in the Workflow Connector. See Workflow Triggers on Dates for additional information on this feature.
