topic Re: How to convert timestamp to date format in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583043#M216529 <HTML><HEAD></HEAD><BODY><P>Try This</P><P></P><P>=Date(Yourdatefield,'DD.MM.YYYY')</P><P></P><P>or </P><P></P><P>your date field in text try like this</P><P></P><P>=date(num(date#(Yourdatefield,'DD.MM.YYYY')),'DD.MM.YYYY')</P></BODY></HTML> Wed, 29 Jan 2014 11:19:19 GMT 2014-01-29T11:19:19Z How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583041#M216527 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have problem with timestamp format dates. Below you'll see some examples.</P><P></P><UL><LI>1.1.2013 08:00</LI><LI>10.1.2014 14:30</LI><LI>31.12.2013 21:30</LI><LI>1.11.2013 01:15</LI><LI></LI></UL><P>What I need is a date (DD.MM.YYYY).</P><P></P><P>I've tested so far almost everything I can find from here. Nothing works. Any good ideas?</P></BODY></HTML> Wed, 29 Jan 2014 11:12:26 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583041#M216527 2014-01-29T11:12:26Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583042#M216528 <HTML><HEAD></HEAD><BODY><P>try tis.</P><P></P><P>Date(Floor( Date(DATE_FIELD)),'DD/MM/YYYY') as DATE</P><P></P><P>-Nilesh</P></BODY></HTML> Wed, 29 Jan 2014 11:14:06 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583042#M216528 nilesh_gangurde 2014-01-29T11:14:06Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583043#M216529 <HTML><HEAD></HEAD><BODY><P>Try This</P><P></P><P>=Date(Yourdatefield,'DD.MM.YYYY')</P><P></P><P>or </P><P></P><P>your date field in text try like this</P><P></P><P>=date(num(date#(Yourdatefield,'DD.MM.YYYY')),'DD.MM.YYYY')</P></BODY></HTML> Wed, 29 Jan 2014 11:19:19 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583043#M216529 2014-01-29T11:19:19Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583044#M216530 <HTML><HEAD></HEAD><BODY><P>Hi Nilesh,</P><P></P><P>Unfortunately that didn't work either...</P></BODY></HTML> Wed, 29 Jan 2014 11:19:30 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583044#M216530 2014-01-29T11:19:30Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583045#M216531 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date(Floor( Date#(DATE_FIELD)),'MM.DD.YYYY hh:mm') as DATE</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">or<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date(Floor( Date#(DATE_FIELD)),'M.D.YYYY hh:mm') as DATE</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">HTH</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Jonathan<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Wed, 29 Jan 2014 11:20:27 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583045#M216531 jonathandienst 2014-01-29T11:20:27Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583046#M216532 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; Use this:- It might help u</SPAN></P><P>SubField <SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">TimeStamp1</SPAN><SPAN style="font-size: 8pt;">,'&nbsp; ', 1) </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Thanks</SPAN></P><P><SPAN style="font-size: 8pt;">D J</SPAN></P></BODY></HTML> Wed, 29 Jan 2014 11:22:10 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583046#M216532 2014-01-29T11:22:10Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583047#M216533 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><IMG alt="2014-01-29_1122.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52281_2014-01-29_1122.png" style="width: 620px; height: 32px;" /></P></BODY></HTML> Wed, 29 Jan 2014 11:23:02 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583047#M216533 rustyfishbones 2014-01-29T11:23:02Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583048#M216534 <HTML><HEAD></HEAD><BODY><P>Sorry, neither of those didn't work</P></BODY></HTML> Wed, 29 Jan 2014 11:24:18 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583048#M216534 2014-01-29T11:24:18Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583049#M216535 <HTML><HEAD></HEAD><BODY><P>=Date(FLOOR(YourDateField),'DD.MM.YYYY')</P></BODY></HTML> Wed, 29 Jan 2014 11:25:53 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583049#M216535 MK_QSL 2014-01-29T11:25:53Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583050#M216536 <HTML><HEAD></HEAD><BODY><P>That works!!! Thanks for your help! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> I mean all of you!</P></BODY></HTML> Wed, 29 Jan 2014 11:30:15 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/583050#M216536 2014-01-29T11:30:15Z Re: How to convert timestamp to date format https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/1627349#M446189 <P>Thanks Nilesh! That helped me too.</P> Tue, 24 Sep 2019 10:02:22 GMT https://community.qlik.com/t5/QlikView/How-to-convert-timestamp-to-date-format/m-p/1627349#M446189 materi 2019-09-24T10:02:22Z