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

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

HI Anonymous 
Here is a video showing a method I used at my place that worked well.

https://www.youtube.com/watch?v=6kKT6QGikMM

If you are still having trouble, please share a sample table with your data.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

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.