Require month and year only

[DS14]

Hi Experts,

I have the field with values in below format, from which I need extract only Month and year.

Month

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Field2_Mar-18 No

Please suggest.

Thanks in advance.

[JordyWegman · Accepted solution]

Hi Deepaksingh,

Do you want them separate? Then use this:

Left(Right(Month,9),3) as Month

Year(20 & Left(Right(Month,5),2)) as Year

If you want the combination then use this:

Left(Right(Month,9),6) as YearMonth

Jordy

Climber