JamesFlowers
Programmer
hi
I have a date formula made from
if {condition}='OPEN' then {instr_date} else if {condition}='CLOSED' then {close_date)
this gets me a single date in a report that a report is either opened or closed on.
But when I go to group the dates , it has to be in line with our accountacy year
which runs on periods like
04/June/2011 to 05/July/2011
06/July/2011 to 01/August/2011
so there isnt a set date period each month (but these dates dont change each year).
When it comes to the december period
11/Dec/2011 to 09/Jan/2012
it goes haywire and the rest of the years dates are put into this banding , and ignore subsequent date ranges.
I am using progress as a DB abd CR11
Many thanks in advance.
JAmes
James Flowers
Crystal Consultant
I have a date formula made from
if {condition}='OPEN' then {instr_date} else if {condition}='CLOSED' then {close_date)
this gets me a single date in a report that a report is either opened or closed on.
But when I go to group the dates , it has to be in line with our accountacy year
which runs on periods like
04/June/2011 to 05/July/2011
06/July/2011 to 01/August/2011
so there isnt a set date period each month (but these dates dont change each year).
When it comes to the december period
11/Dec/2011 to 09/Jan/2012
it goes haywire and the rest of the years dates are put into this banding , and ignore subsequent date ranges.
I am using progress as a DB abd CR11
Many thanks in advance.
JAmes
James Flowers
Crystal Consultant