topic Re: hours in AM/PM in QlikView https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650127#M1055413 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this in your text Obejct</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Time</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">now</SPAN><SPAN style="font-size: 8pt;">(),'hh TT') </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P></BODY></HTML> Fri, 17 Oct 2014 10:05:44 GMT PrashantSangle 2014-10-17T10:05:44Z hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650124#M1055406 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have to create hours from date and then want to show hours in AM/PM..</P><P></P><P>Hour(date) as Hours</P><P>resuult is 11,1,12...but I want 11AM,12PM...etc</P><P>What to do plz reply..</P><P></P><P></P><P>Rahul</P></BODY></HTML> Fri, 17 Oct 2014 09:49:42 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650124#M1055406 2014-10-17T09:49:42Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650125#M1055408 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use</P><P>Time(Date,'hh TT')</P><P>or</P><P>Timestamp(Date,'hh TT'))</P><P></P><P>Regards</P></BODY></HTML> Fri, 17 Oct 2014 09:52:14 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650125#M1055408 PrashantSangle 2014-10-17T09:52:14Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650126#M1055411 <HTML><HEAD></HEAD><BODY><P>its give 11:22:01 AM format...but I want 11AM(which includes time from 11 to 11:59:59)...</P></BODY></HTML> Fri, 17 Oct 2014 09:59:01 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650126#M1055411 2014-10-17T09:59:01Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650127#M1055413 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this in your text Obejct</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Time</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">now</SPAN><SPAN style="font-size: 8pt;">(),'hh TT') </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P></BODY></HTML> Fri, 17 Oct 2014 10:05:44 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650127#M1055413 PrashantSangle 2014-10-17T10:05:44Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650128#M1055416 <HTML><HEAD></HEAD><BODY><P>Hi Rahul,</P><P> </P><P><STRONG style=": ; color: #800080; font-size: 8pt;">time</STRONG><SPAN style="font-size: 8pt;">(</SPAN><STRONG style=": ; color: #ff0000; font-size: 8pt;">Date</STRONG><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #4d0000; font-size: 8pt;">'hh TT'</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">It will give 11 AM as output.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards</SPAN></P><P><SPAN style="font-size: 8pt;">KC</SPAN></P></BODY></HTML> Fri, 17 Oct 2014 10:12:57 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650128#M1055416 jyothish8807 2014-10-17T10:12:57Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650129#M1055418 <HTML><HEAD></HEAD><BODY><P>dear max,</P><P></P><P>its give result 11am,11am,3pm,3pm....... but I want result having distinct hours ... 11am,3am,4pm...</P></BODY></HTML> Fri, 17 Oct 2014 10:14:59 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650129#M1055418 2014-10-17T10:14:59Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650130#M1055421 <HTML><HEAD></HEAD><BODY><P>My required result is shown in attachment ...</P><P></P><P>It should be 1AM,1PM,3AM,3PM...but not 1AM,1AM(REPEAT)...</P></BODY></HTML> Fri, 17 Oct 2014 10:25:55 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650130#M1055421 2014-10-17T10:25:55Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650131#M1055423 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>Mod(Hour(DateTimeField),12)&amp;' '&amp;time(DateTimeField, 'TT') as Hour</P><P></P><P>Hope, there is an easier way and not just striking.</P></BODY></HTML> Fri, 17 Oct 2014 10:58:25 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650131#M1055423 tresB 2014-10-17T10:58:25Z Re: hours in AM/PM https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650132#M1055424 <HTML><HEAD></HEAD><BODY><P>As always ...you are too good tresesco... thanks..</P></BODY></HTML> Fri, 17 Oct 2014 11:01:55 GMT https://community.qlik.com/t5/QlikView/hours-in-AM-PM/m-p/650132#M1055424 2014-10-17T11:01:55Z