Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
So, something like this will be rounded up? or rounded down?
4/16/2018 2:30:30 PM
That will be fine, we just want to filter by date and hour we don't care about the minutes
the Hours will be different depending on how you will round (up or down)
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
Thank you Sunny!!! is working