Power Query: Convert Date Format (Universal Format)

Function: Converts different date formats into YYYY-MM-DD or any other format that you define. You define it in code, it executes!

Date column with mixed date formats

Usage:

 = ConvertToISODate("03/13/2025") → Returns: "2025-03-13"

Power Query code to use and reuse:

let

  ConvertToISODate = (inputDate as any) as nullable text =>

    let

      ConvertedDate = try Date.ToText(Date.From(inputDate), "yyyy-MM-dd") otherwise null

    in

      ConvertedDate

Perfectly cleaned date format in new column

Need a code and instructions? Free of charge =)

pq_ConvertDateFormat.txt

Download TXT • 1KB