Selection of fields between 2 dates

[Dayna]

Hello,

I am hoping that someone here could help me please?
No doubt this will be an easy one... How do I show a selection of fields between two dates?

I was thinking set analysis, create 2 data islands of my date field, and then something like:

({<[Due Date] = {"<=$([Due Date1])>=$([Due Date2])"}>} [Qty Ord])

But unsure on how to do this without using sum... I just want to show the fields between the date range.

You're help would be appreciated!

Kind Regards.
Dayna

[#2]

Dayna Litherland wrote:
Hello Stefan,
Thank you so much for the attached, it is exactly what I am after... Two small (daft) queries, what did you put in the variable and I am not that familiar with triggers yet, how do I put an on change trigger as you have done in the attached?
Kind Regards,
Dayna<div></div>

To set the triggers got to "Document Settings" and "Triggers" and choose the actions for the "variable event triggers" ... these (in my example) are calling a macro which you can find in the macro-editor (Ctrl + M)

Best regards

Stefan

[Dayna]

Hello Stefan,

Many thanks for your quick reply, when I make a change to the source data on your example it stops working. Are you able to identify as to what I am doing wrong?

Please find attached.

Kind Regards,
Dayna