Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
how to chnage the date formats while loading...
if i hve the data with diffrnt date formats?
thanks in advance''''
Suresh
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);
thnx ashwin....its exact wat am lukng.....thanx all for ur replies
thnx peter