Rotating Year Formula???

[PQTIII]

I want to run a report that captures data with a date range of today's date from the same day but a year ago. I guess I'm looking for a rotating year each time the report is ran. What is the best way to accomplish this???

Thanks
Paul
CR9

 

[Madawc]

Try

{field.date} = DateAdd ("y", -1, {currentdate})

I'm not sure how this would cope with leap-years. A fancier alternative would be

if DatePart("d", {currentdate}) <> 29
or Month({currentdate}) <> 2
then {field.date} = Date((year({currentdate})-10), month({currentdate}), DatePart("d", {currentdate}))
else
{field.date} = Date((year({currentdate})-10), month({currentdate}), DatePart("d", {currentdate}))-1

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Madawc]

Correction, use currentdate rather than {currentdate}.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10