date

This function converts an ITP date number to a text. In this text the day and the year will be represented by numbers, but the month by its name. The result depends on the output language. For example; English US: June 21 2009, English UK: 21 June 2009, Dutch: 21 juni 2009 and German: 21 June 2009.

date ( ITP_date_number )

The result of this function is of type TEXT.

This function has one parameter:

1. ITP_date_number, type NUMBER. The ITP date number to be converted to words.

The input must be an ITP date number i.e. a number with a specific format: YYYYMMDD or YYMMDD or CYYMMDD. Use the CYYMMDD format with care, refer to below for more information. Where:

• DD ( days ):between 01 and 31.
• MM ( months ):between 01 and 12.
• YYYY ( years ):between -9999 and 9999.
• YY ( years ):00 and 99, where YY=19YY.
• C (century): 0 or 1, where 0 stands for the 20th and 1 for the 21st century. Thus 0 adds a leading 19 to the year and 1 a leading 20.

Example

@(date(20020617 ) )

Result: 17 June 2002.

Note that the construction @ ( ) around the function means that the result of the function is displayed in the text. This construction must be used in a text part of a model document. The switch from ITP mode to text mode in a model document is made with the # characters. An ITP model document starts in text model, the #BEGIN makes the switch to ITP mode.

If you want the result to be 'the eleventh of September two thousand two' use the function date_to_words( ) instead.

Note

Date format CYYMMDD is intended to allow for an easy transition into the millennium, alas at a small cost: the years 100 – 199 are mapped to 2000-2099. This means that this date format cannot safely be used on historical dates.