Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Change Text Column to Date using Date.FromText

Hi there,    I hope you can help me here. I 've got a column which is called document_field2 which has dates in it as text.  e.g.  80624 170624 Now I try to get these dates using following:  ...
Need Help
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    And if instead you specify a culture, like so:

    = Table.AddColumn(#"Gefilterte Zeilen", "Date", each Date.FromText([document_field2], [Culture="en-GB"]), type date)

     

    This converted all dates without issue for me.

    I hope this is helpful 

m_dekorte's avatar
m_dekorte
Resident Rockstar
2 years ago

Hi Anonymous 

 

Try this instead:

= Table.AddColumn(#"Gefilterte Zeilen", "Date", each Date.FromText([document_field2], [Format="%dMMyy"]), type date)

 

Rick de Groot has an article that can help you, here.

I hope this is helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi m-dekorte, 

    Unfortuneately, there is no change in the result using Format="%dMMyy".
    I had look on this article before and tried several things but didn't work either.