5 Replies Latest reply: Jul 3, 2012 10:17 AM by mattijs.den.otter RSS

    Expression in chart pivot with different dates

      I have the following issue:

       

      In my script I have 3 different dates:

       

      1. KeyDate

      2. Posting Date

      3. Clearing Date

       

      I use the KeyDate in my calender and users can then select a Year and a Month that is linked to the KeyDate.

       

      What I would like to have in my expression in my pivot table is: when an user selects a year and a month, all items with a Posting Date before the last day of that month, but at the same time only the items with a Clearing Date after the last day of that month.

       

      So if for instance March 2012 is selected, I would like to have all items with a Posting Date before 31-03-2012 and also have a Clearing Date after 31-03-2012.

       

      Does anyone know how to do this??

       

      Thx