remove multiple months

[bharatkishore]

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

[vamsee]

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)))