In my table one of the field called "RENEWAL_DATE" is Char 3 value. This field is not a full year date. It represents a day and month within a year. It will have a value of between 1 and 365.
In my dashboard I would like to show like below:
if RENEWAL_DATE =001, then need to show '01-Jan'
if RENEWAL_DATE =032, then need to show '01-Feb'
if RENEWAL_DATE =060, then need to show '01-Mar', like wise I need to show in dashboard. Is it possible?
