https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/2071830#M1231751 <DIV class="mb-sm mb-xs px-md xs:px-0"> <DIV id="t3_jav1s9-post-rtjson-content" class="text-neutral-content md max-h-[253px] overflow-hidden s:max-h-[318px] m:max-h-[337px] l:max-h-[352px] xl:max-h-[452px] text-14 "> <P>Hello, I am loading 3 .xlsx spreadsheets into Qlikview, all contain two date columns, DATE_A &amp; DATE_B, both formatted to dd/mm/yyyy. However, once loaded in, DATE_A reads dd/mm/yyyy, and DATE_B reads yyyymmdd. I require both dates to be presented yyyymmdd. As the spreadsheets are from a 3rd party, I cannot alter them prior to the load. I've tried the Qlikview community site, late last night, both nothing is working so far? Any advised would be greatly appreciated. Thanks</P> </DIV> </DIV> Mon, 26 Jan 2026 16:26:21 GMT honaichas 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/2071830#M1231751 <DIV class="mb-sm mb-xs px-md xs:px-0"> <DIV id="t3_jav1s9-post-rtjson-content" class="text-neutral-content md max-h-[253px] overflow-hidden s:max-h-[318px] m:max-h-[337px] l:max-h-[352px] xl:max-h-[452px] text-14 "> <P>Hello, I am loading 3 .xlsx spreadsheets into Qlikview, all contain two date columns, DATE_A &amp; DATE_B, both formatted to dd/mm/yyyy. However, once loaded in, DATE_A reads dd/mm/yyyy, and DATE_B reads yyyymmdd. I require both dates to be presented yyyymmdd. As the spreadsheets are from a 3rd party, I cannot alter them prior to the load. I've tried the Qlikview community site, late last night, both nothing is working so far? Any advised would be greatly appreciated. Thanks</P> </DIV> </DIV> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/2071830#M1231751 honaichas 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/2071864#M1231753 <P>&nbsp;use this&nbsp; Date(Date#(<SPAN>DATE_A</SPAN>,'<SPAN>dd/mm/yyyy'</SPAN>),'<SPAN>yyyymmdd</SPAN>') on both date fields.&nbsp; &nbsp;</P> Tue, 16 May 2023 12:02:05 GMT https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/2071864#M1231753 md_talib 2023-05-16T12:02:05Z