I am currently creating a report, to track the sales of a particular item, based on the date our customers enrolled in a certain program. The problem I'm running into, is that the program start dates are different for each customer. I thought I had found a formula that would work, but it does not appear to be showing the correct results.

What I need is to see the quantity of said item, purchased between the date of enrollment, and the date of the report being printed.

Here is a sample of the formula I have attempted.
if {p21_sales_history_report_view.invoice_date} in {Sheet1_.Enroll Date} to currentdate then
{p21_sales_history_report_view.qty_shipped}

Please feel free to ask any questions if i have not provided enough info.

Thank you for your help.