month separation from total dates

[#1]

Hi

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

1,

2,

3,

6,

7

is it possible?

[sunny_talwar · Accepted solution]

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

];