The FORMAT_DATE function is used to format dates so they are presented in a readable format, such as the day-month-year (d-m-Y) format here. This function is essential for properly displaying dates in your management systems, while also offering the ability to include the time in the format, depending on the needs.

The output format of FORMAT_NUMBER is always a text, even though it displays formatted numbers. This makes numeric data more readable and easier to integrate into other formulas or displays.

➡️ Display Name:

➡️ Syntax :

➡️ Example:

Here, the date is formatted to display the day (d), month (m), and year (Y) in 4 digits.

➡️ Syntax to display the time 🕦:

• 🟡 date : The date you wish to format.
• "d-m-Y H:i" : Characters for formatting the date's output, where:
  • d represents the day.
  • m represents the month.
  • Y represents the year in 4 digits.
  • H represents the hour (in 24-hour format).
  • i represents the minutes.
• "classic" : Defines that the function is in "classic" mode (default).

➡️ The "classic" mode means that dates will be displayed without the time unless an additional parameter is specified, in the DD/MM/YYYY format (day/month/year).

If you want to add the time to the date format, you can use the additional parameter: 1: Activates the display of the time (note this may not always apply depending on the formula's structure).

ℹ️ The FORMAT_DATE function returns an output format of "text".

For more detailed output format conversion needs, see the technical documentation here 

Key Points:

• TODAY() returns only the current date, without the hours, which you can format as needed with FORMAT_DATE (or with the OPTIONS tab).
• Activating hours in the date column is crucial if you want to include hours and minutes in your formats.
• Use "classic" to display only the date and "1" to include the time.
  
  ℹ️ For more detailed needs for converting output formats see the technical documentation here