Forum Discussion
Solved
Date.ToText Power Querry issue
Hi, I wanted to change date format by using power querry. To do that I ve used "Date.ToText" function. In custom column as you can see I am getting "00" instead of month numbers like "02" , "03"....
Hi kivanct ,
months in the function must be MM because M language is case sensitive. Formula should be then like this:
Date.ToText([Dates],"yyyy-MM")
Overview of all format options can be seen here:
https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
Hi kivanct ,
months in the function must be MM because M language is case sensitive. Formula should be then like this:
Date.ToText([Dates],"yyyy-MM")
Overview of all format options can be seen here:
https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
