Alternative to triggers?

[danielact]

I have an application that tracks insurance policies. Each policy has an effective and expiration date. I have a calendar object where the user can select a date, and it filters to all effective contracts. I do this with a trigger - the calendar is linked to a variable called vInForceDate, and it has a trigger which sets Effective_Date to <=vInForceDate and sets Expiration_Date to >=vInForceDate.

Any idea on how I can do this without triggers so it will work with the AJAX client? I have some users who want to use iPads for it, and you can't use the IE Plugin with it.

[marcus_sommer]

Perhaps this could work with a set analysis condition in the appropriate formulas:

=Count({1<Expiration_Date={">=$(vInForceDate)"}, Effective_Date={"<=$(vInForceDate)"}>} Contracts)

- Marcus

[danielact]

I know I can do that in the expressions, but I want my list boxes to update and show what gets filtered out as well.

[marcus_sommer]

You could use instead a listbox a textbox for showing which date values includes the selection - it is not the same, but it gives users the requieres information.

- Marcus