top of page

BLOGS


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

MirVel
Mar 161 min read
bottom of page




