Convert Date to text and keep the leading 0

[TJCappy]

Hi All,

I am trying to use a date and username to create a key.  

It would seem simple enough but I am strugling with converting the date to text.

The issue I am having is with sindle digit days/months.

when I convert 2022-01-01 to text i get 1/1/2022 and I need to have 01/01/2022.

when I remove the slash "/"  I am now left with 112022  and what i need is 01012022.

If you know a way of doing this I would really apreciate it if you would share it.

Thanks

[Greg_Deckler · Accepted solution]

@TJCappy Try:

= Table.AddColumn(#"Changed Type", "Custom", each Text.Combine({Date.ToText([Column1], "MM"), Date.ToText([Column1], "dd"), Date.ToText([Column1], "yyyy")}), type text)

[TJCappy]

Thanks @Greg_Deckler , worked like a charm

[Greg_Deckler]

@TJCappy FYI, I used Add Columns from Examples to come up with that formula.