IsDate

Description

Determines if a date or time value can be detected and parsed from a character string.

Arguments

1.IsDate- Name of the Macro.

2.Base String - The complete string of characters that contains the value to parse.

3.Format - The optional format string used to check for a date in a specific format. If omitted acceptable formats for the current culture are used.

Examples

[IsDate|04-Sep-1974]

Returns true.

[IsDate|01/24/2000|dd/MM/yyyy]

Returns false. The value looks like a date but the format requests that the day appear before the month and that is why it fails.

Notes

The function only returns the values true and false. Blank values will not be considered date or time values. For a complete list of formatting options see the Date and Time Format Strings topic elsewhere in help.

Send comments on this topic.