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