Forum Discussion
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".
What is to reason for that ? Which function i should use ?
Regards
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
3 Replies
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-stringsDear all, my result shows error, do you know why? i'm sure the column used is datetime format.
