Discussion Board for collaboration on QlikView Scripting.
I have above date format in my excel sheet. But when I load data into my QV document I get the following date format
But I want the date to appear as per excel sheet. Eg 1-OCT-88 pls help me to write script when I load the data to get the desired date format
Try loading like:
Date(DateExcelField, 'DD-MMM-YY') as Date
In the Edit Script there is one SET DateFormat='M/D/YYYY'; change this to the date format which u reqd.
For eg: SET DateFormat='DD-MMM-YY';