Convert YYYYMM date in to Mon-YY format.

[system]

Not sure, but you can try this-

=Month(Max(ToDate(FormatNumber([MonthID];"######"); "yyyyMM"))) + "  " + FormatNumber(Max(Year(ToDate(FormatNumber([MonthID];"######");"yyyyMM")));"####")

I had bit similar requirement, so worked on it. You can refer this-

120×120 10.4 KB

Hi I am trying to implement a formula , but somewhere I am doin wrong. ="Incremental Numbers Of The Branches Between 1 and 275 For the Month of "+Month(Max(ToDate([MIS Account Open Month ID];"MMM"))+" "+FormatNumber(Year(Max(ToDate([MIS Account Open Month];"YYYY")));"####") The value in MIS Account Open Month ID is like (200804,200706) and it should be read as April 2008 or June 2006. Please someone give some suggestion or solution to this problem. Thanks Aniket aniketp (BOB member si…

Edit: You can remove Max from the code as it is not required in your case.
Updated one-

=Month(ToDate(FormatNumber([MonthID];"######"); "yyyyMM")) + "  " + FormatNumber(Year(ToDate(FormatNumber([MonthID];"######");"yyyyMM"));"####")

---

aniketp (BOB member since 2007-10-05)