Discussion Board for collaboration related to QlikView App Development.
I have some dates entered in wrong with wrong year in my data set as shown below
I want to change the year 0020 to 2020 in my all date fields while loading the data . Kindly help me with how to write the data load script it please.
Date(Date#(Wrong,'MM/DD/00YY'),'MM/DD/YYYY') as Correct
View solution in original post