topic Re: Date Format in QlikView https://community.qlik.com/t5/QlikView/Date-Format/m-p/85757#M14064 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DATE(FLOOR(Timestamp#(TRAN_DATE,'MM-DD-YYYY hh:mm:<STRONG>ss TT</STRONG>')),'DD-MM-YY') AS TRAN_DATE1</SPAN></P></BODY></HTML> Wed, 19 Sep 2018 07:19:55 GMT tresB 2018-09-19T07:19:55Z Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/85756#M14063 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><P>I have a field in my data tale namely 'TRAN_DATE' and it is shown below. I have formatted my date field with following script in my data load</P><P>DATE(FLOOR(Timestamp#(TRAN_DATE,'MM-DD-YYYY hh:mm:')),'DD-MM-YY') AS TRAN_DATE1</P><P></P><P>But the result is blank in my output report. Kindly help me</P><P></P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213906_Screenshot_1.png" style="height: auto;" /></P></BODY></HTML> Wed, 19 Sep 2018 07:18:13 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/85756#M14063 upaliwije 2018-09-19T07:18:13Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/85757#M14064 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DATE(FLOOR(Timestamp#(TRAN_DATE,'MM-DD-YYYY hh:mm:<STRONG>ss TT</STRONG>')),'DD-MM-YY') AS TRAN_DATE1</SPAN></P></BODY></HTML> Wed, 19 Sep 2018 07:19:55 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/85757#M14064 tresB 2018-09-19T07:19:55Z