Forum Discussion
Convert data column to date and time
I have such column data:
03-NOV-17 02.43.44.073000000 PM
What I want to get from this - 2 columns:
- date: 03.11.2017
- time: 02:43:44:0730 PM
Can you please help how to do it faster and neat?
I actualy done with Date column, but with Time meet some problems. I get data in this column like this:
2:43:44
but it converts into AM not PM, and without milliseconds.
1 Reply
Hi alunet,
Nope, dax not contains any function to get milliseconds value(format function also not include these)
You can consider to use text formula to store these precision time value in query edit.
Regards,
Xiaoxin Sheng
