Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Date format

hi all,

how to chnage the date formats while loading...

if i hve the data with diffrnt date formats?

thanks in advance''''

Suresh

12 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi Suresh,

Try this script

Data:

LOAD

  salesman,

     city,

     sales,

     Date(Alt(Date#(years, 'DD-MMM-YYYY'), Date#(years, 'MMM-DD-YYYY'), Date#(years, 'YYYY-MMM-DD'), Date#(years, 'MMM-YYYY-DD'), Date(years))) AS Date,

     Actualyears ;

LOAD salesman,

     city,

     sales,

     Capitalize(years) AS years,

     Capitalize(years) AS Actualyears

FROM

[sales.xlsx]

(ooxml, embedded labels, table is Sheet1);

Chanty4u
MVP
MVP
Author

thnx ashwin....its exact wat am lukng.....thanx all for ur replies

Chanty4u
MVP
MVP
Author

thnx  peter