https://community.qlik.com/t5/QlikView/Date-format-not-coming-proper-while-exporting-to-excel-from/m-p/1774170#M454770 <P>Did you activate the date format for your expression?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Frank_Hartmann_0-1610564392751.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46940iF65C67B3BE7E75B7/image-size/medium?v=v2&amp;px=400" role="button" title="Frank_Hartmann_0-1610564392751.png" alt="Frank_Hartmann_0-1610564392751.png" /></span></P><P>&nbsp;</P> Wed, 13 Jan 2021 19:00:01 GMT Frank_Hartmann 2021-01-13T19:00:01Z https://community.qlik.com/t5/QlikView/Date-format-not-coming-proper-while-exporting-to-excel-from/m-p/1774163#M454769 <P>I am using below expression in my qlikview chart straight table.</P><P><U><STRONG>Dimensions</STRONG></U></P><P>=If(vUserInput, if(IsNull(EMP_RELIEVE_DATE) , EMP_RESIGN_DATE), if(not IsNull(EMP_RELIEVE_DATE) , EMP_RELIEVE_DATE))</P><P><U><STRONG>Expressions</STRONG></U></P><P>=If(vUserInput, if(IsNull([EMP_RELIEVE_DATE]) , <STRONG>Date(EMP_RESIGN_DATE+vUserInput))</STRONG>, if(not IsNull([EMP_RELIEVE_DATE]) , EMP_RELIEVE_DATE))</P><P>While exporting into excel, the date format coming as "42301","45219",etc,</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="saivina2920_0-1610563152232.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46936i6EC04C26008BA6D7/image-size/medium?v=v2&amp;px=400" role="button" title="saivina2920_0-1610563152232.png" alt="saivina2920_0-1610563152232.png" /></span></P><P>Is there anything need to change the format in dimensions or expressions...?</P><P>&nbsp;</P> Fri, 15 Nov 2024 23:19:35 GMT https://community.qlik.com/t5/QlikView/Date-format-not-coming-proper-while-exporting-to-excel-from/m-p/1774163#M454769 saivina2920 2024-11-15T23:19:35Z https://community.qlik.com/t5/QlikView/Date-format-not-coming-proper-while-exporting-to-excel-from/m-p/1774170#M454770 <P>Did you activate the date format for your expression?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Frank_Hartmann_0-1610564392751.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46940iF65C67B3BE7E75B7/image-size/medium?v=v2&amp;px=400" role="button" title="Frank_Hartmann_0-1610564392751.png" alt="Frank_Hartmann_0-1610564392751.png" /></span></P><P>&nbsp;</P> Wed, 13 Jan 2021 19:00:01 GMT https://community.qlik.com/t5/QlikView/Date-format-not-coming-proper-while-exporting-to-excel-from/m-p/1774170#M454770 Frank_Hartmann 2021-01-13T19:00:01Z https://community.qlik.com/t5/QlikView/Date-format-not-coming-proper-while-exporting-to-excel-from/m-p/1774241#M454772 <P>Thanks..It's working</P> Thu, 14 Jan 2021 01:24:41 GMT https://community.qlik.com/t5/QlikView/Date-format-not-coming-proper-while-exporting-to-excel-from/m-p/1774241#M454772 saivina2920 2021-01-14T01:24:41Z