Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Convert YYYYMMDDHHMMSS into DD.MM.YYYY

Hello there,  a field called "lastseen" contains a String which represents a date in the format YYYYMMDDHHMMSS. For example 20230516075823.  How can I convert it to DD.MM.YYYY?   I treid the fo...
Need Help
  • BiNavPete's avatar
    BiNavPete
    3 years ago

    Hi Anonymous 

    See attached PBIX here.

    In Powerquery take the left 8 characters by adding a custom column using Text.Start
    Table.AddColumn(Source, "Custom", each Text.Start([StringDate],8))

    Then use Date.FromText on that column
    Table.AddColumn(#"Added Custom", "Date", each Date.FromText([Custom]))

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!

    Pete
    Web: https://binavigation.com
    Linked In: https://www.linkedin.com/in/pete-smith-955b73181

Anonymous's avatar
Anonymous
Not applicable
3 years ago

In the Video he hast the Format YYYMMDD. In my case I habe the format YYYYMMDDHHMMSS, when I follow the Steps in the Video I get a Error. 

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

Hi Anonymous 
As I mentioned in my previous response, I would be happy to assist,
Please share the data table in a format that I can work with.
Thanks, Rita.