aging report

need help in using Aged0To30Days in crystal report 9

this is formula i'm using:

create formula @.test as
if {arinvc.dinvoice} in currentdate to currentdate-30 then
"Aged0To30Days"
else if {arinvc.dinvoice} in currentdate-31 to currentdate-60 then
"AgedAged31To60Days"
else if {arinvc.dinvoice} in currentdate-61 to currentdate-90 then
"AgedAged61To90Days"
else if {arinvc.dinvoice} in currentdate-91 to currentdate-120 then
"AgedAged91To120Days"
else
"others"

this is the error message after i check the formula:

the remain text does not appear to be part of the formula

tnxuse

create formula @.test as
if {arinvc.dinvoice} in [currentdate to currentdate-30] then
"Aged0To30Days"

[ ] brackets i added.

hope this helps|||ok. i'll try it here. tnx|||sorry

i didn't mention earlier

in clause takes comma seperated value like

in [1,2,3,4]