ValidDate

The ValidDate function determines whether the string provided in the parameter is a calendar date in a valid format.

The function returns true if the string is a calendar date in one of the following formats.
  • YYYYMMDD
  • YYMMDD
This function returns false if the string is not in one of these formats or has an invalid value for the month, day, or year.

Return type

The function return type is: BOOLEAN

Function parameters

Table 1. ValidDate assignment function parameters
Parameter order Input variable type Parameter data type Required parameter Description
1 Data field STRING Yes The string to be checked against the valid date formats.