Sum of sales within date range

[jorgen_santberg]

Hi all,

I am trying to get the number of sales sold in a promotion period to a specific customer. The salesdate and calendar have the field time, while the promocalendar has a startdate and an enddate.

If I select the month August for example, I want to see all the promotions per customer that started or ended in that specific month and the volume sold between the startdate and enddate of the promotion.

The fields of my salesdata are:

- customer

- sales

- time

- article

The field of my promotiontable are:

- startdate

- enddate

- customer

- article

- promotion # (= Rowno())

Help would be very much appreciated!

[vishsaggi]

May be you want interval match check here:

Intervalmatch example – with dates

[jorgen_santberg]

Hi yes this partly solves it, thanks! The only challenge I have now is that I have to create all possible combinations between Customer, Time and Article from a date in the past to a date in the future (because otherwise I can not see the promotions planned in the future). I will check the forum for the solution, but any help in the meantime would be great!