topic Re: date and time in QlikView https://community.qlik.com/t5/QlikView/date-and-time/m-p/810149#M1027032 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this in script</P><P></P><P>LOAD</P><P>Date(DATE, 'DD/MM/YYYY') AS DATE,</P><P>TIME(TIME, 'hh:mm:ss TT') AS TIME</P><P>FROM DataSource;</P><P></P><P>REgards,</P><P>Jagan.</P></BODY></HTML> Mon, 02 Mar 2015 03:55:21 GMT jagan 2015-03-02T03:55:21Z date and time https://community.qlik.com/t5/QlikView/date-and-time/m-p/810148#M1027031 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Need some assistance with Date and Time fields. I have got an extract below from excel (sample also attached):</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 252px; border-collapse: collapse;"><TBODY><TR style="height: 15pt;"><TD height="20" style="border: 0px black; width: 82pt; height: 15pt; background-color: transparent;" width="109"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">DATE</SPAN></TD><TD style="border: 0px black; width: 107pt; background-color: transparent;" width="143"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">TIME</SPAN></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; height: 15pt; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">16/07/2010</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">9:43:00 AM</SPAN></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; height: 15pt; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">16/07/2010</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10:24:00 AM</SPAN></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; height: 15pt; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">17/07/2010</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">12:34:00 AM</SPAN></TD></TR><TR style="height: 15pt;"><TD align="right" class="xl65" height="20" style="border: 0px black; height: 15pt; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">17/07/2010</SPAN></TD><TD align="right" class="xl66" style="border: 0px black; background-color: transparent;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4:49:00 AM</SPAN></TD></TR></TBODY></TABLE><P><BR /> When its loaded in Qlikview it appears as below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 393px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border: 0.5pt solid gainsboro; width: 102pt; height: 12.75pt; background-color: whitesmoke;" width="136"><STRONG style="color: #333333; font-family: Tahoma;">DATE</STRONG></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 193pt; background-color: whitesmoke;" width="257"><STRONG style="color: #333333; font-family: Tahoma;">TIME</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2010-07-16</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">09:43:00.00000000000042375</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2010-07-16</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">10:24:00.00000000000127800</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2010-07-17</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">00:33:59.999999999999946525</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">2010-07-17</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">04:48:59.99999999999834700</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>I want it to appear as:</P><P></P><P>date: 13/07/2011 </P><P>time: 15:23:12</P><P></P><P>Please assist.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 02 Mar 2015 03:36:00 GMT https://community.qlik.com/t5/QlikView/date-and-time/m-p/810148#M1027031 Anonymous 2015-03-02T03:36:00Z Re: date and time https://community.qlik.com/t5/QlikView/date-and-time/m-p/810149#M1027032 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this in script</P><P></P><P>LOAD</P><P>Date(DATE, 'DD/MM/YYYY') AS DATE,</P><P>TIME(TIME, 'hh:mm:ss TT') AS TIME</P><P>FROM DataSource;</P><P></P><P>REgards,</P><P>Jagan.</P></BODY></HTML> Mon, 02 Mar 2015 03:55:21 GMT https://community.qlik.com/t5/QlikView/date-and-time/m-p/810149#M1027032 jagan 2015-03-02T03:55:21Z Re: date and time https://community.qlik.com/t5/QlikView/date-and-time/m-p/810150#M1027033 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Jagan.</P><P></P><P>Really appreciated it.</P><P></P><P>Cheers!!!</P></BODY></HTML> Mon, 02 Mar 2015 04:16:21 GMT https://community.qlik.com/t5/QlikView/date-and-time/m-p/810150#M1027033 Anonymous 2015-03-02T04:16:21Z Re: date and time https://community.qlik.com/t5/QlikView/date-and-time/m-p/810151#M1027034 <HTML><HEAD></HEAD><BODY><P>HI Jagan Can u please look on my discussion and please suggest me some answer , </P></BODY></HTML> Mon, 02 Mar 2015 04:46:24 GMT https://community.qlik.com/t5/QlikView/date-and-time/m-p/810151#M1027034 2015-03-02T04:46:24Z