I have tried a few different formulas in Crystal Reports for retrieving sales analysis data for certain time frames and cannot get any of them to come up with the correct calculation that I need. If anyone can help me it would be much appreciated.

I need three separate calculations …

10 Week Sales (back from today)
1 Week Sales (back from today)
3 Weeks Sales – (Precious year from today ahead 3 weeks)

Here are two of the formulas I have tried for the previous year’s sales – they both return the exact same total - ALL of the quantity ever sold instead of just the total sold within the date range.

IF {SR65A Transactions.Date} = (CURRENTDATE -365) TO_ (CURRENTDATE -344) THEN
sum({SR65A Transactions.Quantity sold}) ELSE
0

On this one I created a parameter to ask for the date range.

IF {SR65A Transactions.Date} = {?3 Week Prior Year} THEN
sum({SR65A Transactions.Quantity sold}) ELSE
0

I am obviously way off track here or completely missing something.
Please help…