topic Date in QlikView https://community.qlik.com/t5/QlikView/Date/m-p/1751407#M719932 <P>Hi All,&nbsp;</P><P>I have date field from oracle in the below format of the screenshot , I am converting this into QVD and in the 2nd layer when i try to conevrt this format to 'DD/MM/YYYY' this is not working . I tried all the possible methods but i am not able to convert this date format Could someone please help me on this ?&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smilingjohn_0-1602481628040.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/42058iA5FC1E124AF4AFA0/image-size/medium?v=v2&amp;px=400" role="button" title="smilingjohn_0-1602481628040.png" alt="smilingjohn_0-1602481628040.png" /></span></P><P>Thanks in Advance</P> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z Date https://community.qlik.com/t5/QlikView/Date/m-p/1751407#M719932 <P>Hi All,&nbsp;</P><P>I have date field from oracle in the below format of the screenshot , I am converting this into QVD and in the 2nd layer when i try to conevrt this format to 'DD/MM/YYYY' this is not working . I tried all the possible methods but i am not able to convert this date format Could someone please help me on this ?&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="smilingjohn_0-1602481628040.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/42058iA5FC1E124AF4AFA0/image-size/medium?v=v2&amp;px=400" role="button" title="smilingjohn_0-1602481628040.png" alt="smilingjohn_0-1602481628040.png" /></span></P><P>Thanks in Advance</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1751407#M719932 smilingjohn 2020-11-25T16:16:04Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1751409#M719933 <P>This got worked with below function&nbsp;</P><P>date(floor(Date),'DD/MM/YYYY') as Date</P> Mon, 12 Oct 2020 06:02:30 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1751409#M719933 smilingjohn 2020-10-12T06:02:30Z