4 Replies Latest reply: Apr 18, 2012 8:58 AM by Neil Henderson RSS

    Set Analysis Help: Showing Dates Prior to a Selected Date

      Hi All,

       

      I'm having issues with a set analysis. I want to display only data in a straight table that has [Inception Date] less than [Date], which I select from a list box.

       

      Inputting only({$<[Inception Date]=[Date]>}[Vhl 1 Age]) woks, and returns all data where the inception date is equal to whichever date i select.

       

      Inputting only({$<[Inception Date]={'<2011-02-01 00:00:00'}>}[Vhl 1 Age]) also works, and returns all data where the inception date is before 01/02/2011.

       

      However, inputting {'<Date'}, {'<[Date]'} or {'<$[Date]'} in place of a specified date doesn't return any values.

       

      Any assistance here would be greatly appreciated.

       

      Ross