hi, i want to change date format in item monthly summary report 19-Sep to 19-9 hope some will help thaks
this i will change the default format for day breakup Code: [#System: Formula] DayFormat : $$String:$DayOfFromDate + "-" +$$String:@@Monthnumber Monthnumber :if $ShortPeriodDateFrom = "Jan" then 1 else if $ShortPeriodDateFrom = "feb" then 2 else if $ShortPeriodDateFrom = "Mar" then 3 + else if $ShortPeriodDateFrom ="Apr" then 4 else if $ShortPeriodDateFrom = "May" then 5 else if $ShortPeriodDateFrom = "Jun" then 6 + else if $ShortPeriodDateFrom = "Jul" then 7 else if $ShortPeriodDateFrom = "Aug" then 8 + else if $ShortPeriodDateFrom = "Sep" then 9 else if $ShortPeriodDateFrom = "Oct" then 10 else if $ShortPeriodDateFrom = "Nov" then 11 + else if $ShortPeriodDateFrom = "Dec" then 12 else 0
Code: [#Line: DSP accline] add: left field: at end : yeardisplaya local:field:yeardisplaya:set:$$number:$$YearOfDate:$$perioddatefrom [field:yeardisplaya] use : simple prompt color : Blue skip : yes try this