get item numbered list depending on a range of dates
I need your help.
I have 3 lists: Product, rate, invoice
and two modules:
I want to put in invoices.valid rate the max number# of rate list where all following conditions are satisfied:
- Rates.status = true
- Invoice.Prod name = rates.prod name
- Rates.start date < Invoice.Invoice date < rates.end date
Can you help me?