Date Format Issue

chang0986 — Tue, 23 May 2023 15:49:30 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

PrashantSangle — Tue, 23 May 2023 16:31:13 GMT

in your load script modify it. using Date() and Date#()

for DD/MM/YYYY field date use Date(Date#(yourdatefield,'DD/MM/YYYY'),'YYYYMMDD')

for yyyymmdd you can keep it as it is.

Regards

Prashant Sangle

topic Date Format Issue in QlikView

Date Format Issue

Re: Date Format Issue