month separation from total dates

Fri, 19 Feb 2016 09:58:39 GMT

My data is like this

1/1/2015,

1/2/2015,

1/3/2015,

4/6/2015,

12/7/2015

from this data i want to separate month as a column data like

is it possible?

Re: month separation from total dates

sunny_talwar — Fri, 19 Feb 2016 10:33:08 GMT

Try doing this:

Num(Month(DateField)) as MonthNum

Script:

Table:

LOAD Date,

Month(Date) as Month,

Num(Month(Date)) as MonthNum;

LOAD * Inline [

Date

1/1/2015

1/2/2015

1/3/2015

4/6/2015

12/7/2015

];