The FormatDate() function converts a date to text

Syntax

FormatDate(date, format)
FormatDate(date, language)

Returns

A new text string that is the text representation of a date.

Parameters

  • date – a date
  • format – the format is used to specify how the date should be represented
  • language – this parameter is used to specify the date representation of that language

If the format or language parameter contains an unknown value, then the default portal language is used to format the string.

See the microsoft documentation to learn more about format strings.

Examples

FormatDate(Now(), "MM-dd-yyyy")
/* returns "05-30-2017" */

FormatDate(Now(), "MMMM dddd dd yyyy")
/* returns "May Tuesday 30 2017" */

FormatDate(Now(), "ddd hh:mm tt")
/* returns "Tu 01:54 PM" */

FormatDate(Now(), "ddd HH:mm")	
/* returns "Tu 13:54" */

FormatDate(Now(), en_US)
/* returns "5/30/2017 01:54:00 PM" */

FormatDate(Now(), nl_NL)
/* returns "30-5-2017 13:54:30" */

 +31 (0)20 240 21 20       

Videos and images courtesy of WEM Modeler. © 2019. WEM Modeler.
SitemapPrivacy - Terms - Company

 +31 (0)20 240 21 20       


Videos and images courtesy of WEM Modeler.
© 2019 WEM Modeler.
SitemapPrivacy - Terms - Company