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
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.
