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
| Parameter | Description | Format |
|---|---|---|
| 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 semicolon (;), and the date. | n.a. |
| Date | Date in YYMMDD or YYYYMMDD format. | script literal or script variable |
| Calendar | Name of the Calendar object. | AE name, script literal or script variable |
| Calendar Event | Name of the Calendar Event. | AE name, script literal or script variable |
Return Codes
The VALID_CALE function returns the following values:
| Return Value | Condition |
|---|---|
| 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")
See also: