This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Please find the attached xl. In my database my date formate is like that what i am attached.
so, from that only i am going to create date field.
The problem is.
I did all formatting steps in my edit script but still i cant get the correct formate.
Anybody facing the similiar problem before.
Please let me know
The following should work
Dates:LOAD [no], Date(Date#(Date, 'YYYYMMDD')) AS DateFROMDate.xlsx(ooxml, embedded labels, table is Sheet1);
Date(Date#(Date, 'YYYYMMDD')) AS Date
(ooxml, embedded labels, table is Sheet1);
You first do the representation with the Date#() function, then the interpretation as date with the Date() function.
Hope that helps.
Miguel Angel Baeyens
Comex Grupo Ibérica
View solution in original post
What are those zeros in date column, if you dont need them then use where to filter out them. Then use
makedate ( left ( date, 4 ), mid ( date, 5, 2 ), right(date, 2 )) as newdate.
from which data source u generate this excel ?
Thanks to all,