Two calendar with from and to dates

[renjithpl]

Hi All,

I have two date fields, one is Trade_Date and seconde one is Maturity Date.

Now i want to have two from and to date options, (pls see attachment)

User will able to select both ranges in Trade date and maturity date, and click on a button.

All the trades happend in that date range and out of that how many matured in the range of maturity date should be displayed.

Please let me know if you need more clarity on this.

Thanks

Ren

[Clever_Anjos]

1) Create 4 variables and attach calendars to each one

2) Use Set Analysis to filter your data according to variables

Example

SUM({< Trade_Date={">=$(var1)"}*{">=$(var2)"}, [Maturity Date]={">=$(var3)"}*{">=$(var4)"}>}Value)

[#3]

Hi,

I have made it through Button Click event as well as through SET analysis. See the attachment.

FYI - I just used Trades From and To date.