Forum Discussion
Solved
Convert date from YYYYMMDDHHMM to HH:MM
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?
bouyazbekj if it is datetime field then you can use format
MyTime = FORMAT( Table[Your Date Time Column], "HH:MM" )
bouyazbekj if it is datetime field then you can use format
MyTime = FORMAT( Table[Your Date Time Column], "HH:MM" )
Thank you