https://community.qlik.com/t5/App-Development/Converting-dates-in-Qliksense/m-p/1917976#M75509 <P>Hello All,</P> <P>I have below date :-</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aspiring_Developer_0-1649848342662.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76980i05DCE5A6F3CDDBF6/image-size/large?v=v2&amp;px=999" role="button" title="Aspiring_Developer_0-1649848342662.png" alt="Aspiring_Developer_0-1649848342662.png" /></span></P> <P>I wish to convert it into dd/mm/yyyy format .</P> <P>I have tried below :-</P> <P>MONTHname(Date#(ISSUE_CLOSED_DATE,'DD/MM/YYYY')) as ISSUE_CLOSED_DATE_test</P> <P>But it giving me blank results. I am assuming that it is varchar format , so i tried to convert it into number using num function , however it didn't work.</P> <P>Can anyone please help ?</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 13 Apr 2022 11:15:16 GMT Aspiring_Developer 2022-04-13T11:15:16Z https://community.qlik.com/t5/App-Development/Converting-dates-in-Qliksense/m-p/1917976#M75509 <P>Hello All,</P> <P>I have below date :-</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aspiring_Developer_0-1649848342662.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/76980i05DCE5A6F3CDDBF6/image-size/large?v=v2&amp;px=999" role="button" title="Aspiring_Developer_0-1649848342662.png" alt="Aspiring_Developer_0-1649848342662.png" /></span></P> <P>I wish to convert it into dd/mm/yyyy format .</P> <P>I have tried below :-</P> <P>MONTHname(Date#(ISSUE_CLOSED_DATE,'DD/MM/YYYY')) as ISSUE_CLOSED_DATE_test</P> <P>But it giving me blank results. I am assuming that it is varchar format , so i tried to convert it into number using num function , however it didn't work.</P> <P>Can anyone please help ?</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 13 Apr 2022 11:15:16 GMT https://community.qlik.com/t5/App-Development/Converting-dates-in-Qliksense/m-p/1917976#M75509 Aspiring_Developer 2022-04-13T11:15:16Z https://community.qlik.com/t5/App-Development/Converting-dates-in-Qliksense/m-p/1917984#M75510 <P><SPAN>Date(Date#(ISSUE_CLOSED_DATE,'DD-MMM-YYYY'),'DD/MM/YYYY')&nbsp;as ISSUE_CLOSED_DATE</SPAN></P><P>See also&nbsp;<A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157" target="_blank" rel="noopener">https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157</A>&nbsp;</P> Wed, 13 Apr 2022 11:28:28 GMT https://community.qlik.com/t5/App-Development/Converting-dates-in-Qliksense/m-p/1917984#M75510 hic 2022-04-13T11:28:28Z