FormatDate

The FormatDate and IncrementDate Functions

April 14, 2011 User Reference
Thumbnail image for The FormatDate and IncrementDate Functions

FormatDate Date data elements can be formatted according to the format patterns defined for the .NET framework. For example: <<FormatDate(dateofengagement,”yyyy-MM-dd”)>> <<FormatDate(dateofengagement,”dd MMM yyyy”,”af”)>> <<FormatDate(dateofdismissal,”d MMMM, yyyy”)>> <<FormatDate(dateofSignature,”MMMM o yyyy”)>> These examples would result in something like, respectively: 2008-02-29 29 Februarie 2008 29 February, 2008 February 29th 2008. Except for the Afrikaans example, the other results [...]

Read the full article →