Forum Discussion

TJCappy's avatar
TJCappy
Frequent Visitor
3 years ago
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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    TJCappy Try:

    = Table.AddColumn(#"Changed Type", "Custom", each Text.Combine({Date.ToText([Column1], "MM"), Date.ToText([Column1], "dd"), Date.ToText([Column1], "yyyy")}), type text)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

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's avatar
TJCappy
Frequent Visitor
3 years ago

Thanks Greg_Deckler , worked like a charm

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

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