You are here: Features > Cell Functions > Date and Time Functions > FMTDATESTR 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 active CaseView document was last saved was August 18, 2014, "August 18, 2014" in Spanish would appear in the cell.

Related Topics