FORMAT_DATETIME

Converts a date to formatted text.

Sample usage

FORMAT_DATETIME("%c", Order Date)

Syntax

FORMAT_DATETIME(format_string, datetime_expression)

Parameters

format_string - See Supported Format Elements For DATETIME for a list of format elements that this function supports.

date_expression - a Date or a Date & Time field or expression.

Return data type

Text1

Examples

Formula Result
FORMAT_DATETIME("%x", DATE "2008-12-25")
12/25/08
FORMAT_DATETIME("%c", DATETIME "2008-12-25 15:30:00")
Thu Dec 25 15:30:00 2008
FORMAT_DATETIME("%b-%d-%Y", DATETIME "2008-12-25 15:30:00")

Dec-25-2008

Notes

This function is not available for compatibility mode date types.

  1. Date strings may be interpreted as compatibility mode Date data types. To preserve the specified format, change the field type to Text.

Related resources

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
102097
false