topic Re: Date is loading wrong when I change the alias in QlikView

Date is loading wrong when I change the alias

ellyodelly — Mon, 03 Mar 2014 19:01:41 GMT

I am loading data from a QVD- it has a creation date , then I load the date again with an alias and it appears wrong. I have done this a number of time before not sure what I did wrong this time.. day and year appear to be ok- but month is wrong.

please view attached.

Re: Date is loading wrong when I change the alias

hic — Mon, 03 Mar 2014 19:12:58 GMT

It seems to me as if the qvd has been created with an incorrect format code, e.g. mm/dd/yyyy instead of MM/DD/YYYY. Note that the format is case sensitive and that m means minutes and M means months.

HIC

Re: Date is loading wrong when I change the alias

chiru_thota — Mon, 03 Mar 2014 19:23:42 GMT

Can you try below while loading data ?

Load

round((Timestamp([SO Order Date],'MM/DD/YYYY') as tod,

round((Timestamp([SO Order Date],'MM/DD/YYYY hh.mm.ss') as [Calendar Date]

...

Re: Date is loading wrong when I change the alias

ellyodelly — Mon, 03 Mar 2014 19:32:26 GMT

thanks! I forgot about the case sensitive... will have to go back and recheck all of my QVD creation files. always a day to learn!