Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have written the following code to get month in script
Date(Makedate((LEFT(Period,4)),(Right(Period,2)),01),'MMM') as Month
But i am getting repetitive months. like Jan,feb..dec again jan,,feb..dec
Can you please help me how to remove those.
Thanks,
Bharat
Can you provide a sample of your field Period?
Also, try
Month(Makedate((LEFT(Period,4)),(Right(Period,2)),01))
or
Month(Date#(MakeDate((LEFT(Period,4)),(Right(Period,2)),01)))