In Between text

[srini]

Hi There, I am using 

Text between and Date function together to achieve Month name in my requirement.

the source is: M01 Units

The expression which I have used is 

Date(Num(TextBetween([Month],'M',' Uni')),'MMM') as [Month],

The result for text between is 01 and when it convert to Date it should show as Jan but it shows as Dec.

I am not sure why it is showing wrong???

[PrashantSangle]

use date#() and Date() together

try like
date(Date#(Num(TextBetween([Month],'M',' Uni')),'MM'),'MMM') as Month

Regards,

[srini · Accepted solution]

Great!!

Thanks a lot it is working fantastic! 

[PrashantSangle]

Please close thread by selecting answer as correct solution.

[sunny_talwar]

You can try this with the Month function

Month(Date#(Num(TextBetween([Month],'M',' Uni')),'MM')) as [Month],