date range options

[#1]

Hi

(eg)I am creating a bar chart listing no.of orders placed by each customer in my database. now i wish to see the only the no of orders placed by him from this particular date to this particular date. kindly give with examples

[giakoum]

Assuming that particular dates limits are placed in variables vFromDate and vToDate :

count({$<[OrderPlacedDate]={">=$(vFromDate)<=$(vToDate)"}>} [Orders])