Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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