Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
Great!!
Thanks a lot it is working fantastic!
You can try this with the Month function
Month(Date#(Num(TextBetween([Month],'M',' Uni')),'MM')) as [Month],