Table of contents
Collapse the table of content
Expand the table of content


Owen Duncan|Last Updated: 10/5/2018
1 Contributor

Date.ToText(date as nullable date, optional format as nullable text, optional culture as nullable text) as nullable text


Returns a textual representation of date, the Date value, date. This function takes in an optional format parameter format. For a complete list of supported formats, please refer to the Library specification document.

Example 1

Get a textual representation of #date(2010, 12, 31).

Date.ToText(#date(2010, 12, 31))

Example 2

Get a textual representation of #date(2010, 12, 31) with format option.

Date.ToText(#date(2010, 12, 31), "yyyy/MM/dd")
© 2018 Microsoft