Comparing Dates

[tmumaw]

I have a request for a QV model where the user can enter a from date and to date.  The from and to dates will be used to determine a range for showing all tickets that were either open or closed during that period.  I have both open and closed dates on my ticket table.  Does anyone have any recommendations on how to only select only the tickets that were either open or closed during the range the user selected.

Thanks

[sushil353]

hi,

Try this:

step1: Create two variablt say: vstartdate and venddate

step2: create two calander objects/inputbox to assigne the desired dates to those variables..

step3: you can use those variables in the setanalysis like

=only({<opendate={">=$(vstartdate)"},closedate={"<=$(venddate)"}>}tickets)

HTH

Sushil