Straight Table - show data based on date selections

[daniel1990xyz]

Hello everyone,

I have the following problem and I am glad for any help.

I have a "static" data table with date frame information (FromDate - ToDate) for each entry. Based on a Date selection in a field I would like to show in a straight table the entries from the static table when one of the selected dates are between the date frame. Please check the image for a better explanation. In this example the green underlined entries should be visible in the straight table based on the selected dates (green highlighted).

I have tried to implement this by using set analysis and aggr as an expression in the straight table but without any success.

Thank you in advance for any help.

Best regards,

Daniel

[sunny_talwar]

I think you need to make changes to your script. You can create an IntervalMatch between your datefield and your From and To dates. Check here about IntervalMatch: IntervalMatch