remove multiple months

bharatkishore — Fri, 21 Sep 2018 14:16:32 GMT

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

Re: remove multiple months

vamsee — Fri, 21 Sep 2018 14:33:49 GMT

Can you provide a sample of your field Period?

Also, try

Month(Makedate((LEFT(Period,4)),(Right(Period,2)),01))

Month(Date#(MakeDate((LEFT(Period,4)),(Right(Period,2)),01)))