CAS 6

---

formatdate2

- Date

Summary

Format dates by specification. Result is text and invalid dates return blank.

Description

Format dates by specification. Result is text and invalid dates return blank.

Any backslash () must be escaped by doubling the character. I.e. 'm\d\y'

See http://v6x.carlislegroup.com/enhancements/467

Examples

'd' formatdate2 MTDATE 
'm/d/y' formatdate2 NPDATE mminus 1

Syntax

'DateFmt' formatdate2 DateField

Left Arguments

Name	Data Type	Input Type	Description	Optional	Default
DateFmt	Text	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

Build 6.0.1062