1 of 1 people found this helpful
What you can do is set your discrete date to hours, then right click on the blue pill>Format. In the format pane on the left, you can choose the 12 hour format in the Header tab under Dates.
Hope this solves your question!
You can create a calculated field that tests your date field and checks if the hour is less than 12 and splits the values accordingly.
After you've created the calculated field, you can place it before your date field on the columns shelf and you'd get something like the following:
This is the calc:
IF DATEPART('hour',[Time Stamp])<12
Hope this helps!
Thanks a lot.
Can you please mark the answer as correct if it solved you issue?