topic How to change Date/Hour Structure in App Development https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11559#M817 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>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:</P><P></P><P>(4/16/2018 2 PM), <SPAN style="font-size: 13.3333px;">(4/16/2018 3 PM)</SPAN> I just need the date and the hour, if someone know how to it will be a great help!!.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 24 Apr 2018 13:06:25 GMT jhona1737 2018-04-24T13:06:25Z How to change Date/Hour Structure https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11559#M817 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>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:</P><P></P><P>(4/16/2018 2 PM), <SPAN style="font-size: 13.3333px;">(4/16/2018 3 PM)</SPAN> I just need the date and the hour, if someone know how to it will be a great help!!.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 24 Apr 2018 13:06:25 GMT https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11559#M817 jhona1737 2018-04-24T13:06:25Z Re: How to change Date/Hour Structure https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11560#M818 <HTML><HEAD></HEAD><BODY><P>So, something like this will be rounded up? or rounded down?</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">4/16/2018 2:30:30 PM</SPAN></P></BODY></HTML> Tue, 24 Apr 2018 13:12:06 GMT https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11560#M818 sunny_talwar 2018-04-24T13:12:06Z Re: How to change Date/Hour Structure https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11561#M819 <HTML><HEAD></HEAD><BODY><P>That will be fine, we just want to filter by date and hour we don't care about the minutes</P></BODY></HTML> Tue, 24 Apr 2018 13:18:06 GMT https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11561#M819 jhona1737 2018-04-24T13:18:06Z Re: How to change Date/Hour Structure https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11562#M820 <HTML><HEAD></HEAD><BODY><P>the Hours will be different depending on how you will round (up or down)</P></BODY></HTML> Tue, 24 Apr 2018 13:23:44 GMT https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11562#M820 YoussefBelloum 2018-04-24T13:23:44Z Re: How to change Date/Hour Structure https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11563#M821 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>TimeStamp(TimeStamp#(Left(TimeStamp(FieldName, 'MM/DD/YYYY hh:mm:ss'), 13), 'MM/DD/YYYY hh'), 'MM/DD/YYYY hh TT') as NewField</STRONG></P></BODY></HTML> Tue, 24 Apr 2018 13:26:32 GMT https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11563#M821 sunny_talwar 2018-04-24T13:26:32Z Re: How to change Date/Hour Structure https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11564#M822 <HTML><HEAD></HEAD><BODY><P>Thank you Sunny!!! is working</P></BODY></HTML> Tue, 24 Apr 2018 13:37:54 GMT https://community.qlik.com/t5/App-Development/How-to-change-Date-Hour-Structure/m-p/11564#M822 jhona1737 2018-04-24T13:37:54Z