get month and year from month/year

[arulsettu]

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?

[jayaseelan]

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);