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.