Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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