VALID_CALE

Script Function: Checks whether a date is included in the calendar keyword

Syntax

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

Syntax

Description/Format

Date

Calendar

Name of the Calendar object
Format: AE name, script literal or script variable

Calendar Keyword

Name of the calendar keyword
Format: AE name, script literal or script variable


Return codes

"Y" - The date is included in the calendar keyword
"N" - The date is not included in the calendar keyword

Comments

Optionally, you may specify a particular Date Format. The default Date Formats to be used are "YYMMDD" or "YYYYMMDD". A colon or semicolon may be used as a separator between Date Format and Date.

Examples

The example shown below checks if the current date is valid within the work schedule calendar. The return value of the function is stored in a script variable.

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

See also:

Script element Description

VALID_DATE

Checks if the date is valid.

VALID_TIME

Checks if a time is valid.

Script Elements - Date and Time

Date, Time and Period Formats

About Scripts
Script Elements - Alphabetical Listing

Script Elements - Ordered by Function