FORMAT_DATETIME

Converts a date or date and time to formatted text.

Sample usage

FORMAT_DATETIME("%c", Order Date)

FORMAT_DATETIME( format_string, date_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 ¹

Example formula	Output
`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.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-22 UTC.