Function: format()


format(<Date>, <Format>) : Text

format(<Date>, <Format>, <Culture>) : Text

The format function is used to format the specified date parameter. It also provides a function overload to display the value in different cultures.

For more information about formatting and cultures, check out the following articles:


When you use static dates, you need to enclose the value with the # symbol. The date should be in the following format - dd/mm/yyyy hh:mm

format(#01/02/2021 12:00#, "dd-MM-yyyy") => "01-02-2021"

format(#01/02/2021 12:00#, "dddd d MMMM", "it-IT") => "Mercoledì 1 Febbraio"

Learn more about how you can get started using the Formula Field.

What would you improve in this article?
Powered by:

Type above and the results will be displayed here.