topic Date Format Issue in QlikView

Date Format Issue

octuslimb — Tue, 28 Sep 2021 17:48:00 GMT

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

Re: Date Format Issue

stevejoyce — Tue, 28 Sep 2021 18:00:37 GMT

What if you load in like:

date#(DATE_B, 'yyyymmdd') as DATE_B

You also need to handle blanks/nulls which can prevent the field from being loaded as a date. You can try this in the beginning of the load script:

NullInterpret = '';

Re: Date Format Issue

Chip_Matejowsky — Wed, 29 Sep 2021 17:37:27 GMT

Moving this thread to the QlikView App Dev forum.