(null Date, null 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")
Comments
Please sign in to leave a comment.