Discussion board where members can get started with QlikView.
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.
Go to Solution.
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.
View solution in original post
Can you try below while loading data ?
round((Timestamp([SO Order Date],'MM/DD/YYYY') as tod,
round((Timestamp([SO Order Date],'MM/DD/YYYY hh.mm.ss') as [Calendar Date]
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!