FORMAT

(null Datenull dateFormat)
Returns date in specified format.
Example: FORMAT(DATE(2008, 3, 9, 16, 5, 7), "MM/dd/yyyy") returns 03/09/2008.
Date: Required. The date.

Example 1

A date column usually comes in the US English format - as seen in the first column. To present the date in the "dd-MM-yyyy" format:

format(&Date,"dd-MM-yyyy")

Example 2

Full Month Name from date:

format(&Date,"MMMM")

Pattern options:

Example 3

Extensively formatted date:

format(&Date,"ddd dd MMM yyyy")

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.