The FORMAT_DATE() function lets you format how a date is displayed.
The result is always text, even if it represents a date.

Function name

FORMAT_DATE()

Syntax

1️⃣ Without time (date only)

FORMAT_DATE(value, "DD/MM/YYYY")

or

FORMAT_DATE(value, "DD-MM-YYYY")

2️⃣ With time

FORMAT_DATE(value, "DD/MM/YYYY HH:mm", "classic", 1)

or

FORMAT_DATE(value, "DD-MM-YYYY HH:mm", "classic", 1)

Supported formats

Date only

• DD/MM/YYYY

• DD-MM-YYYY

Date + time

• DD/MM/YYYY HH:mm

• DD-MM-YYYY HH:mm

Parameters

• value : column or value of type Date

• format :

  • DD → day

  • MM → month

  • YYYY → year (4 digits)

  • HH → hour (24h)

  • mm → minutes

• "classic" : default mode

• 1 : enables time display

The time is displayed only if the Date column has the “Time enabled” option.

Return type

ℹ️ FORMAT_DATE() always returns TEXT