Forum Discussion
Solved
Convert Date to text and keep the leading 0
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
TJCappy Try:
= Table.AddColumn(#"Changed Type", "Custom", each Text.Combine({Date.ToText([Column1], "MM"), Date.ToText([Column1], "dd"), Date.ToText([Column1], "yyyy")}), type text)
3 Replies
- Greg_Deckler
Community Champion
TJCappy Try:
= Table.AddColumn(#"Changed Type", "Custom", each Text.Combine({Date.ToText([Column1], "MM"), Date.ToText([Column1], "dd"), Date.ToText([Column1], "yyyy")}), type text)Thanks Greg_Deckler , worked like a charm
- Greg_Deckler
TJCappy FYI, I used Add Columns from Examples to come up with that formula.
