Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
Or even this:
Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')
How about this:
Timestamp([Interaction Start Date Time UTC], 'h TT')
or
Timestamp(Floor([Interaction Start Date Time UTC], 1/24), 'h TT')
Or even this:
Timestamp(Floor(Frac([Interaction Start Date Time UTC]), 1/24), 'h TT')