Power Query: Convert Date Format (Universal Format)

Updated: Feb 24

PRACTICE MATERIAL BELOW!👇

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

Usage:

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

let

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

let

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

ConvertedDate

ConvertToISODate

Need a code and instructions? Free of charge =)

Recent Posts