DateTime.ToText
DateTime.ToText(dateTime as nullable datetime, optional options as any, optional culture as nullable text) as nullable text
Returns a textual representation of dateTime
. An optional record
parameter, options
, may be provided to specify additional properties. culture
is only used for legacy workflows. The record
can contain the following fields:
Format
: Atext
value indicating the format to use. For more details, go to Standard date and time format strings and Custom date and time format strings. Omitting this field or providingnull
will result in formatting the date using the default defined byCulture
.Culture
: WhenFormat
is not null,Culture
controls some format specifiers. For example, in"en-US"
"MMM"
is"Jan", "Feb", "Mar", ...
, while in"ru-RU"
"MMM"
is"янв", "фев", "мар", ...
. WhenFormat
isnull
,Culture
controls the default format to use. WhenCulture
isnull
or omitted, Culture.Current is used.
To support legacy workflows, options
and culture
may also be text values. This has the same behavior as if options = [Format = options, Culture = culture]
.
Convert #datetime(2010, 12, 31, 01, 30, 25)
into a text
value. Result output may vary depending on current culture.
Usage
DateTime.ToText(#datetime(2010, 12, 31, 01, 30, 25))
Output
"12/31/2010 1:30:25 AM"
Convert using a custom format and the German culture.
Usage
DateTime.ToText(#datetime(2010, 12, 30, 2, 4, 50.36973), [Format="dd MMM yyyy HH:mm:ss.ffffff", Culture="de-DE"])
Output
"30 Dez 2010 02:04:50.369730"
Convert using the ISO 8601 pattern.
Usage
DateTime.ToText(#datetime(2000, 2, 8, 3, 45, 12),[Format="yyyy-MM-dd'T'HH:mm:ss'Z'", Culture="en-US"])
Output
"2000-02-08T03:45:12Z"