1 Reply Latest reply: Apr 9, 2013 7:01 AM by Sushil Kumar RSS

    Comparing Dates

    Thom Mumaw

      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

        • Re: Comparing Dates
          Sushil Kumar

          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