Forum Discussion
Solved
Convert Date_Time format to DDMMYYYYHHMMSS numeric format.
Hello Everyone,
Can someone help with the below problem?
I want to convert the Date_Time column into the "DDMMYYYYHHMMSS" numeric format using Power BI Query Editor only.
| DATE_TIME | Resulted column |
| 01-Jan-24 10:17:41 PM | 1012024221741 |
| 01-Jan-24 10:22:34 PM | 1012024222234 |
| 01-Jan-24 10:25:12 PM | 1012024222512 |
| 01-Jan-24 10:28:30 PM | 1012024222830 |
| 01-Jan-24 10:30:56 PM | 1012024223056 |
| 01-Jan-24 10:33:41 PM | 1012024223341 |
Thanks in Advance!
add a custom column and use following code.
DateTime.ToText(DateTime.From([DATE_TIME], "en-us"), [Format = "ddMMyyyyHHmmss"])If you are using an English system, you can remove "en-us". For example, the following code.
DateTime.ToText(DateTime.From([DATE_TIME]), [Format = "ddMMyyyyHHmmss"])
2 Replies
add a custom column and use following code.
DateTime.ToText(DateTime.From([DATE_TIME], "en-us"), [Format = "ddMMyyyyHHmmss"])If you are using an English system, you can remove "en-us". For example, the following code.
DateTime.ToText(DateTime.From([DATE_TIME]), [Format = "ddMMyyyyHHmmss"])- Thanks a lot! the concern has been solved.
