Forum Discussion
Time format [h:mm tt]
I have a text field which contains value in the form of: 10:30:00 14:00:00 When I tell that this field contains time value and apply the time format [h:mm tt] the result is 10:30 tt 14:...
As of today, this still seems to be an issue...
I found another SQL blog that pointed me to using AM/PM instead of the t or tt format it it works. My format command is this
FORMAT(DateTable[Date]),"M/d h:mm AM/PM")
This particular format shows "9/29 11:32 AM"
Works great
rgines, formatting on import can be a good way to go.
The tt option within the data model does work now though.
Good to know. I'm working within the desktop tool within a Measure. It doesn't work there with the tt option. Have to use AM/PM. Might work with A/P but I didn't try that.
