Returns a value to indicate if a string holds a valid date, as indicated by a specified pattern.
d is the string expression that represents a date. d specifies the input date to be evaluated as a character string representing date/time according to the pattern specified with p.
p is a supported date/time pattern. This parameter is optional. If specified, it specifies the date/time pattern of d. If not specified, VALIDDATE uses the default date/time pattern YYYYMMDDHHMISS999.
w specifies an expression (such as 1976) that can be converted to an integer. A negative value specifies an offset to be subtracted from the value of the year when the code runs. If not specified, w VALIDDATE uses the value specified in the WINDOW option.
Description
The VALIDDATE function returns a '1'B if the string d holds a date/time value that matches the pattern specified by p.
Both the d and p parameters must have computational type and should have character type. If not, they are converted to character.
If the pattern specified by p contains punctuation characters, VALIDDATE checks that the input string contains matching characters. For example, if specifying YYYY-MM-DD, VALIDDATE accepts 2015-03-14 but not 2015.03.14 or 2015/03/14.
See the help topic Date/Time Built-in Functions for more information about supported date/time patterns.