Show data from date range that is -1 year from query

[spinbad]

Greetings,

using crystal reports 8.5 getting data from a progress database. I was wondering if there is a way to select data from -1 year from the user entered parameter query in a formula?

So if the user enters 1-1-05 - 1-1-06, the formula will select data from 1-1-04 - 1-1-05

 

[synapsevampire]

Sure, go to Report->Edit Selection Formula->Record and use something like:

(
{table.date} >= dateserial(year(minimum{{?MyDateRange})-1),month(minimum{{?MyDateRange})),day(minimum{{?MyDateRange})))
and
{table.date} <= dateserial(year(maximum{{?MyDateRange})-1),month(maximum{{?MyDateRange})),day(maximum{{?MyDateRange})))

-k