Date Formatting Help

[rosscortb]

Hello,

I am trying to change the date format,  I want the start date to showing in a Table Chart as numbers not text, i.e YYYY - MM, so 2019 -10 but when I was adding a column in the query the year works but the month goes to single digits meaning Jan displays as 1 not 01, any ideas, thanks Ross

[v-xicai · Accepted solution]

Hi  @rosscortb ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[rosscortb]

Or if I can get just get the Start_Date column to show as YYYY/MM then that would work

[v-xicai]

Hi @rosscortb ,

Enter into Query Editor, click on Add Custom Column and then put in the following syntax:

Text.PadStart(Text.From([Start_date-Copy.1]),2,"0")

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.