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.
Type above and the results will be displayed here.