Forum Discussion
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 following code from Solved: Converting Text into Date - Microsoft Power BI Community
Table.TransformColumns(#"_RSALL_FULL_PERNR-USERS",{{"lastseen", each if _ = "0" then null else Text.Insert(_,8,"T"), type text}})
But I get the error: Expression.Error: The name '_RSALL_FULL_PERNR-USERS' wasn't recognized. Make sure it's spelled correctly.
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
4 Replies
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-955b73181HI 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 quicklyHi 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.
