Hi, I recently got stuck with a crystal reports job and need help generating a formula.

The Data is connected via ADO to a Microsoft SQL database.

the data is for current units rented. and has a field of unit_rent.

how do I generate the formula for units rented last week.

I apologize again if that's not enough information. let me know what else you might need