https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/1905247#M1227492 <P>Assuming they are being read as dates, you can just use date(DATE_A) and date(DATE_B) to format both to your app's default (or you can manually set the format, e.g. date(DATE_A,'yyyymmdd') )</P> <P>If they aren't being read as dates, you'll need to apply date#() during your load or otherwise get Qlik to recognize them as dates.</P> Tue, 15 Mar 2022 10:15:25 GMT Or 2022-03-15T10:15:25Z https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/1905231#M1227491 <DIV class="_3xX726aBn29LDbsDtzr_6E _1Ap4F5maDtT1E1YuCiaO0r D3IL3FD0RFy_mkKLPwL4" data-click-id="text"> <DIV class="_292iotee39Lmt0MkQZ2hPV RichTextJSON-root"> <P class="_1qeIAgB0cPwnLhDF9XSiJM">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 21:26:37 GMT https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/1905231#M1227491 makauchan 2026-01-26T21:26:37Z https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/1905247#M1227492 <P>Assuming they are being read as dates, you can just use date(DATE_A) and date(DATE_B) to format both to your app's default (or you can manually set the format, e.g. date(DATE_A,'yyyymmdd') )</P> <P>If they aren't being read as dates, you'll need to apply date#() during your load or otherwise get Qlik to recognize them as dates.</P> Tue, 15 Mar 2022 10:15:25 GMT https://community.qlik.com/t5/QlikView/Date-Format-Issue/m-p/1905247#M1227492 Or 2022-03-15T10:15:25Z