VALID_CALE

Use the VALID_CALE script function to verify whether a particular date is included in a Calendar Event.

Syntax

VALID_CALE ([Date Format:]Date, Calendar, Calendar Event)

Parameters

VALID_CALE
Checks if the date is included in the Calendar Event
Date Format
(Optional) You can define a date format of your choice by entering your required date format, adding a separator such as a colon (:) or a semi colon (;), and the date.
Date
Date in YYMMDD or YYYYMMDD format.
Format: script literal or script variable
Calendar
Name of the Calendar object
Format: AE name, script literal or script variable
Calendar Event
Name of the Calendar Event
Format: AE name, script literal or script variable

Return codes

Y
The date is included in the Calendar Event
N
The date is not included in the Calendar Event

Examples

The following example checks if the current date is valid within the on-call calendar. The return code of the script function is passed on in a script variable.

:SET &CURDATE# = SYS_DATE()
:SET &OPERATOR#=VALID_CALE(&CURDATE#,"ONCALL","WORKDAY")