Training
Module
Text manipulation in Power Automate for desktop - Training
Learn how to manipulate text and datetime values in Power Automate for desktop.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Date.ToText(date as nullable date, optional options as any, optional culture as nullable text) as nullable text
Returns a textual representation of date
. 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
: A text
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 providing null
will result in formatting the date using the default defined by Culture
.
Culture
: When Format
is not null, Culture
controls some format specifiers. For example, in "en-US"
"MMM"
is "Jan", "Feb", "Mar", ...
, while in "ru-RU"
"MMM"
is "янв", "фев", "мар", ...
. When Format
is null
, Culture
controls the default format to use. When Culture
is null
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 #date(2010, 12, 31)
into a text
value. Result output may vary depending on current culture.
Usage
Date.ToText(#date(2010, 12, 31))
Output
"12/31/2010"
Convert using a custom format and the German culture.
Usage
Date.ToText(#date(2010, 12, 31), [Format="dd MMM yyyy", Culture="de-DE"])
Output
"31 Dez 2010"
Find the year in the Hijri calendar that corresponds to January 1st, 2000 in the Gregorian calendar.
Usage
Date.ToText(#date(2000, 1, 1), [Format="yyyy", Culture="ar-SA"])
Output
"1420"
Training
Module
Text manipulation in Power Automate for desktop - Training
Learn how to manipulate text and datetime values in Power Automate for desktop.