Solved: Re: Convert date from YYYYMMDDHHMM to HH:MM

bouyazbekj · ‎04-15-2019

Hello,

I have a date in form of text that I'd like to turn into hours and minutes only. (HH:MM)

Example

201904151015 to 10:15

Any idea how to do this?

parry2k · ‎04-15-2019

@bouyazbekj if it is datetime field then you can use format

 MyTime = FORMAT( Table[Your Date Time Column], "HH:MM" )

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎04-15-2019

@bouyazbekj if it is datetime field then you can use format

 MyTime = FORMAT( Table[Your Date Time Column], "HH:MM" )

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

bouyazbekj · ‎04-15-2019

Thank you

Anonymous · ‎04-15-2019

Hi,

So, you're saying it's a text column? Well, I'd do it in Power Query. I'd go to Transform > Split Column > By Number of Characters. Choose 8 characters. Then in the split column that has the hours and minutes part as "1015", just change the type to time.