How to change Date/Hour Structure

[jhona1737]

Hello All,

I a got a set of data that shows like this: 4/16/2018 2:30:30 PM as the picture, what I am trying to do is to show like this:

(4/16/2018 2 PM), (4/16/2018 3 PM) I just need the date and the hour, if someone know how to it will be a great help!!.

Thank you!

[sunny_talwar]

So, something like this will be rounded up? or rounded down?

4/16/2018 2:30:30 PM

[jhona1737]

That will be fine, we just want to filter by date and hour we don't care about the minutes

[YoussefBelloum]

the Hours will be different depending on how you will round (up or down)

[sunny_talwar · Accepted solution]

May be this

TimeStamp(TimeStamp#(Left(TimeStamp(FieldName, 'MM/DD/YYYY hh:mm:ss'), 13), 'MM/DD/YYYY hh'), 'MM/DD/YYYY hh TT') as NewField

[jhona1737]

Thank you Sunny!!! is working