TEXTDATE - Extract a date from a string (Reports & Settings Report Generator function)
From Catalyst
Syntax
$TEXTDATE{textdate, format}
Description
Extract a date from a string, specifying the format it is in.
Parameters
- textdate
- A text parameter that can be omitted.
- The string that contains the date.
- format
- A text parameter that can be omitted (it defaults to "DD/MM/CCYY").
- The format that the textdate is in.
- D
- This character at this position in the string is a day.
- M
- This character at this position in the string is a month. This can either be a number or the name of a month.
- Y
- This character at this position in the string is part of a two digit year.
- C
- This character at this position in the string is part of a two digit century.
Returns
A numeric value. The number of days the date is after 1st January, 1900.