Date Formula

[leebird1]

Hi,

I currently have this long string that I need the date extracted from. The date pieces for below is as follow:
YEAR = 2017
MONTH = Dec (this is because January is 0 so in this sample Month=11 is Dec)
Day_OF_MONTH=28

Would it be possible to have a formula that extracts the date and produces 28-Dec

currently I have this formula but the month is incorrect (showing Jan instead of Dec)
=SUBSTITUTE(MID(A2,SEARCH(",DAY_OF_MONTH=",A2)+14,2),",","")&TEXT("01-"&(SUBSTITUTE(MID(A2,SEARCH(",MONTH=",A2)+7,2),",",""))+0,"-mmm")


java.util.GregorianCalendar[time=1514437200000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="America/New_York",offset=-18000000,dstSavings=3600000,useDaylight=true,transitions=235,lastRule=java.util.SimpleTimeZone[id=America/New_York,offset=-18000000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2017,MONTH=11,WEEK_OF_YEAR=52,WEEK_OF_MONTH=5,DAY_OF_MONTH=28,DAY_OF_YEAR=362,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=4,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-18000000,DST_OFFSET=0]

 

[Legacy 143009]

In my case it is showing 28-Nov. Anyway, you can make a fine tune by adding +1 or substracting -1 to the month.