Instead of changing the date format from header section
Click on the date time Field --> Default Properties --> Date --> Change the format and drag it to filter now you can see the required O/P.
Hope this helps.
Plz mark this answer as helpful or correct to close the thread.
Thanks for the response.
Can we show the
12 AM Instead of 0 AM???
12 AM Instead of 12 PM???
I have tried it but it's now working. Could you please share any screenshot or Twbx file for this? So that it will helpful for me to achieve this one.
Finally I found the the way.
Use the following calculation for 12 Hrs conversion,
IF STR(DATEPART('hour',[DateTime]))='12' THEN "12 PM"
ELSEIF STR(DATEPART('hour',[DateTime]))='0' THEN "12 AM"
ELSEIF DATEPART('hour',[DateTime])>12 THEN STR(DATEPART('hour',[DateTime])-12)+" PM"
ELSE STR(DATEPART('hour',[DateTime]))+" AM"
Step 2 : Drag the field to "filter" you will see the wrong order. Then just go to the Field >> Right Click >> Default Properties >> Sort >> Manual Sort