Power Query
published
Search
K
Comment on page

Date.ToText

Date.ToText

Returns a textual representation of the Date value.
function (optional date as nullable any, optional format as nullable any, optional culture as nullable any) as nullable any

Description

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.

Category

Date

Examples

Get a textual representation of #date(2010, 12, 31).
Date.ToText(#date(2010, 12, 31))
"12/31/2010"
Get a textual representation of #date(2010, 12, 31) with format option.
Date.ToText(#date(2010, 12, 31), "yyyy/MM/dd")
"2010/12/31"