Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps this could work with a set analysis condition in the appropriate formulas:
=Count({1<Expiration_Date={">=$(vInForceDate)"}, Effective_Date={"<=$(vInForceDate)"}>} Contracts)
- Marcus
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.
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