The source file that I am trying to load has a date field as shown below:
It clearly is displaying the date in a different format. when I pull this field into QlikView, for some reason it is not considering the year. I tried different combinations of Date & Date# but in vein.
How can I pull the date field in DD/MM/YYYY format without making any changes to the excel sheet?
You can do
Date(Date#(Date, 'Your Excel Format'), 'Required Format')
Thank you for the response.
Ain't working. It is picking a dummy Year.
Correction, I am using a CSV file and not an excel, If that makes a difference.
Date(Date#(Date, 'MM/DD/YYYY'), 'DD/MM/YYYY')
What are you getting when you change environment to below
SET TimestampFormat='DD/MM/YYYY h:mm:ss[.fff] TT';
Try in a simple way..as in the excel file..the date format is MM/DD/YYYY.. so you just need to change it to DD/MM/YYYY
date(Date,'DD/MM/YYYY') as Date