Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Format Timestamp by Hour

I would like to show data by hour 12am - 12pm.  The expression below works, but I would like to display the PM time as 1pm, 2pm, 3pm, etc. instead of 13pm, 14pm, 15pm, etc.

Any suggestions on how to update to adjust the timestamp for the PM hours? 

Timestamp([Interaction Start Date Time UTC], 'h') & Timestamp([Interaction Start Date Time UTC],'TT')

1 Solution

Accepted Solutions
sunny_talwar

Or even this:

Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')

View solution in original post

2 Replies
sunny_talwar

How about this:

Timestamp([Interaction Start Date Time UTC], 'h TT')

or

Timestamp(Floor([Interaction Start Date Time UTC], 1/24), 'h TT')

sunny_talwar

Or even this:

Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')