CAS 6

makedate
- Date

Summary

Convert a text or numeric field to a date field using a specified-date format. Any character except '1234567890' may be used as a delimiter. If a date format is not specified, CAS will make an intelligent guess.

Examples

makedate FIELD
'serial' makedate FIELD
'MMYYYY' makedate FIELD
'[YY]YYDDD' makedate FIELD
'DD-JAN-YY' makedate FIELD
'YYMMDD' makedate FIELD
'M/D/Y' makedate FIELD
'Y-M' makedate FIELD

Syntax

(DateFormat) makedate Field

Left Arguments

Name	Data Type	Input Type	Description	Optional	Default
DateFormat	Date	Constant	Any permutation of '[YY]YY' 'MM' '[DD]' with or with out delimiters.; Text Constant	Yes

Right Arguments

Name	Data Type	Input Type	Description	Optional	Default
Field	Text	Field, Constant		No

Result

Type: Date