how to convert month?

[daisy1438]

Hi

I have one date field like below.

Date

201701

201702

201703

.

.

.

.

201712

it showing like that i need creating the month field.in that i want show only months.

Thanks

daisy

[m_woolf]

num(right(Date,2)) as Month

[shiveshsingh]

load Month(Date#(Date,'YYYYMM')) as month