FORMAT_DATETIME

Converts a date to formatted text.

Sample usage

FORMAT_DATETIME("%c", Order Date)

FORMAT_DATETIME(format_string, datetime_expression)

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.

Text¹

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

This function is not available for compatibility mode date types.

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

Was this helpful?

How can we improve it?