topic How to convert into 2 fields date and time in QlikView

topic How to convert into 2 fields date and time in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-into-2-fields-date-and-time/m-p/384869#M143777 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="130"><TBODY><TR><TD class="xl63" height="17" width="130">8/11/12 11:51:56 AM</TD></TR><TR><TD class="xl63" height="17" style="border-top: medium none;">8/9/12 11:17:06 AM</TD></TR><TR><TD class="xl63" height="17" style="border-top: medium none;">8/17/12 12:59:30 PM</TD></TR></TBODY></TABLE><P></P><P>I tried timestamp#( ,'DD/MM/YYYY hh:mm:ss')</P><P>I tried date#(  ,'DD/MM/YYYY')</P></BODY></HTML> Thu, 06 Sep 2012 11:23:35 GMT tanjavarwijk 2012-09-06T11:23:35Z How to convert into 2 fields date and time https://community.qlik.com/t5/QlikView/How-to-convert-into-2-fields-date-and-time/m-p/384869#M143777 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="130"><TBODY><TR><TD class="xl63" height="17" width="130">8/11/12 11:51:56 AM</TD></TR><TR><TD class="xl63" height="17" style="border-top: medium none;">8/9/12 11:17:06 AM</TD></TR><TR><TD class="xl63" height="17" style="border-top: medium none;">8/17/12 12:59:30 PM</TD></TR></TBODY></TABLE><P></P><P>I tried timestamp#( ,'DD/MM/YYYY hh:mm:ss')</P><P>I tried date#(  ,'DD/MM/YYYY')</P></BODY></HTML> Thu, 06 Sep 2012 11:23:35 GMT https://community.qlik.com/t5/QlikView/How-to-convert-into-2-fields-date-and-time/m-p/384869#M143777 tanjavarwijk 2012-09-06T11:23:35Z Re: How to convert into 2 fields date and time https://community.qlik.com/t5/QlikView/How-to-convert-into-2-fields-date-and-time/m-p/384870#M143778 <HTML><HEAD></HEAD><BODY><P>use date#(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">8/11/12 11:51:56 AM,'DD/MM/YY'</SPAN>)</P><P>time#(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">8/11/12 11:51:56 AM,'hh:mm:ss'</SPAN>)</P></BODY></HTML> Thu, 06 Sep 2012 11:28:02 GMT https://community.qlik.com/t5/QlikView/How-to-convert-into-2-fields-date-and-time/m-p/384870#M143778 rajni_batra 2012-09-06T11:28:02Z