CAS 6

formatdate
- Date

Summary

Format a date as a character field, with the exception of converting to serial. Serial result will be numeric. This function may used to calculate a temporary field for a data list report.

Description

Note that you will not be able to sort appropriately on the date field once it has been converted to character.

Left Argument Result

1 -> 4-Mar

2 -> 3/4/1995

3 -> Mar-95

4 -> 4-Mar

5 -> 4-Mar-95

6 -> 4-Mar-95

7 -> Mar-95

8 -> Mar-95

9 -> 4-Mar-95

10 -> 3/4/1995

11 -> 3/4/1995

12 -> Mar-95

13 -> 1995 March

14 -> 4/3/1995

15 -> 4/3/1995

16 -> 3/4/1995

17 -> 95/03

18 -> 4-Mar-95

19 -> serial

20 -> YYYY-MM

Examples

1 formatdate MTDATE 
9 formatdate NPDATE mminus 1

Syntax

'DateFmt' formatdate DateField

Left Arguments

Name	Data Type	Input Type	Description	Optional	Default
DateFmt	Numeric	Constant	See description	No

Right Arguments

Name	Data Type	Input Type	Description	Optional	Default
DateField	Date	Field, Constant	yyyymmdd	No

Result

Type: Text, Numeric

Formatted dates