Date Format Issue

[makauchan]

Hello, I am loading 3 .xlsx spreadsheets into Qlikview, all contain two date columns, DATE_A & 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

[Or]

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') )

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.