Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i am having data like this
Year
03/2016
03/2015
01/2016
12/2015
01/2015
05/2015
06/2015
02/2016
11/2015
08/2015
10/2015
04/2016
05/2016
09/2015
07/2015
04/2015
02/2015
];
i did the following
LOAD*,
month(SubField(Year,'/','1')) as newmonth,
Year(SubField(Year,'/','1')) as newyear;
but not getting the result
any idea?
Hi,
try this,
Year:
LOAD*,
Month(Date#(SubField(Year,'/','1'),'M')) as newmonth,
Date#(mid(Year,4),'YYYY')as newyear;
LOAD Year
FROM
C:\Users\GIS\Desktop\Temp.xlsx
(ooxml, embedded labels, table is Sheet1);