DateTime.ToText

Syntax

DateTime.ToText(dateTime as nullable datetime, optional format as nullable text, optional culture as nullable text) as nullable text

About

Returns a textual representation of dateTime. An optional format may be provided to customize the formatting of the text. An optional culture may also be provided (for example, "en-US").

Example 1

Get a textual representation of #datetime(2011, 12, 31, 11, 56, 2).

DateTime.ToText(#datetime(2010, 12, 31, 11, 56, 2))
"12/31/2010 11:56:02 AM"

Example 2

Get a textual representation of #datetime(2011, 12, 31, 11, 56, 2) with format option.

DateTime.ToText(#datetime(2010, 12, 31, 11, 56, 2), "yyyy/MM/ddThh:mm:ss")
"2010/12/31T11:56:02"