so - I have seen plenty of advice on converting integer fields into dates along with formatting as per below:
date(MonthStart(%_WO_Requested),'MMM-YY') as [Start Month]
date(MakeDate (1970,01,01)+ FLD_REPORTING_CLEAREDTIME /24/60/60,'MMM-YY') as Resolve_Month,
Both of these statements do the job, however, instead of leaving me with a list of 12 dates for a year (e.g. Jan-16, feb-16 etc etc), i get a massive list of dates that appear to be the same (e.g. Jan-16,Jan-16,Jan-16,Feb-16, Feb-16 etc etc).
I think this is because the underlying integer is a unique number which represents day, month, year, hours, minutes and seconds.
There are 2 date representations that are extracted from the remedy system:
so, my question is, once i have converted the date into MMM-YY, how do i create a calendar object that only shows the 12 months for the year, and not a date for each unique integer number?