4 of 4 people found this helpful
Mike - To parse the AM/PM correctly, you will need to change the format to this: notice the 'a' in the format section on the below.
DATEPARSE ("hh:mm a", [Fill Time])
Your dateparse formula has specified a parse string of "hh:mm". Based on that, tableau will only parse the hh:mm portion. If you have two rows, one containing 5:00 AM and 5:00 PM, they will come through exactly the same as the hour portion is the same. Change your string to "hh:mm a".
Plenty of good threads on the forum covering this, please be sure to run a quick search next time! Dateparse on "12/25/14 5:51 PM"