Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jhona1737
New Contributor II

How to change Date/Hour Structure

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!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: How to change Date/Hour Structure

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

5 Replies
MVP
MVP

Re: How to change Date/Hour Structure

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

4/16/2018 2:30:30 PM

jhona1737
New Contributor II

Re: How to change Date/Hour Structure

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

YoussefBelloum
Esteemed Contributor

Re: How to change Date/Hour Structure

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

MVP
MVP

Re: How to change Date/Hour Structure

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
New Contributor II

Re: How to change Date/Hour Structure

Thank you Sunny!!! is working

Community Browser