Custom calendars

The following Expression Editor functions are available for use with the custom calendar feature. For more information about setting up calendars, see the Kofax Insight Admin Console Help.

DATE_ADD_BUSINESS: This group of functions supports the ability to use a custom calendar to add or subtract days, hours, and minutes, so they always fall on a business day. For example, if you add 1 day on a Friday, the result is Monday, because the non-business days of Saturday and Sunday are ignored.

The following functions are available:

• DATE_ADD_BUSINESS_DAYS (Number, Date, Calendar)

• DATE_ADD_BUSINESS_HOURS (Number, Date, Calendar)

• DATE_ADD_BUSINESS_MINUTES (Number, Date, Calendar)

IS_BUSINESS_DAY: This group of functions is used to evaluate a date-time value and return "True" if it falls within a defined business day for a custom calendar.

The following functions are available:

• IS_BUSINESS_DAY (Date, Calendar)

• IS_BUSINESS_TIME (Date, Calendar)

DATE_DIFF_BUSINESS: This group of functions is used to evaluate the difference between two dates to calculate business time. The function returns the count of days, hours, or minutes.

The following functions are available:

• DATE_DIFF_BUSINESS_DAYS (Start Date, End Date, Calendar)

• DATE_DIFF_BUSINESS_HOURS (Start Date, End Date, Calendar)

• DATE_DIFF_BUSINESS_MINUTES (Start Date, End Date, Calendar)