RE:Date format

[Chanty4u]

hi all,

how to chnage the date formats while loading...

if i hve the data with diffrnt date formats?

thanks in advance''''

Suresh

[jagan]

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]

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

[Chanty4u]

thnx  peter