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
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:
Moving this thread to the QlikView App Dev forum.