Date formats

Previous  Top  Next

Description

Remember that if the date has been entered and defined as a date, the value stored will be 'internal format' i.e. as an integer number representing the number of days since 31st December 1967.

Syntax

We can therefore manipulate this in many ways by using standard Multi-Value statements to show the date in 'external format' these are:

D2/ will show the value as a date format with a / (slash) between each second dig from the right of the resulting date. Example: 1st July 2001 will show 1/07/01. D2. will show as D2/ but the separator will be. (full-stops). Example: 1st July 2001 will show 1.07.01 Other separators can be used in place of the slash. DM will show the month number only. DD will show the day number only. DY will show the year only e.g. 2001. D2Y will show the year only e.g. 01. DWE will show the day as a day name not a number e.g. Monday or Saturday. DW will show the day as the day of the week. Example: 1 as Sunday, 7 as Saturday. DQ will show the quarter number of the year. Example: 1 for January to March 4 for October to December. DJ will show a day number from the start of year Example: 1st January will be 1; 1st March will be 59 (or 60 if leap year).

Remarks

None