Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
ellyodelly
Creator
Creator

Date is loading wrong when I change the alias


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.

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

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

View solution in original post

3 Replies
hic
Former Employee
Former Employee

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

chiru_thota
Specialist
Specialist

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]

...

ellyodelly
Creator
Creator
Author

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!