• Date and Time Functions
  • ADDMONTH Function
  • ADDYEAR Function
  • Date and Time Functions
  • Day Function
  • DAYSTR Function
  • DMY Function
  • DTOS Function
  • FMTDATESTR function
  • ITOD Function
  • LDATE Function
  • MKDATE Function
  • MONTH Function
  • MONTHSTR Function
  • PERSTR Function
  • PERTOJ Function
  • SDATE Function
  • SDATETOJ Function
  • SYSDATE Function
  • SYSTIME Function
  • VERDATE Function
  • VERSION Function
  • VERTIME Function
  • YEAR Function

FMTDATESTR function

The FMTDATESTR function returns a formatted date string in a specified language.

Syntax

FMTDATESTR(date value, date format, ISO 639-1 language code)

Examples

• FMTDATESTR(SYSDATE(), "ddd")

Returns the abbreviated string of the day of the week in the current user locale. If the day of the week is Monday, "Mon" appears in the cell.

• FMTDATESTR(SYSDATE(), "MMMM", "ru")

Returns the full month string in Russian. If the current month was August, "August" in Russian would appear in the cell.

• FMTDATESTR(SYSDATE(), "MMMM dd,yyyy", "fr")

Returns the date string in French. If the current date was August 18, 2014, "August 18, 2014" in French would appear in the cell.

• FMTDATESTR(VERDATE(), "MMMM dd, yyyy ", "es")

Returns the date string in Spanish. If the last date the current CaseView document was last saved was August 18, 2014, "August 18, 2014" in Spanish would appear in the cell.

Related Topics

• Date and Time Functions