7 Replies Latest reply: Jun 19, 2014 3:48 AM by Fabio Morciano RSS

    Count of dates greater than 30 days old

    David Simpson

      Hi all, I'm sure this is simple but it's doing my head in...

       

      How do I count the number of orders that have a date associated with them which is greater than 30 days old?

       

      I've tried loads of variations of the following

       

      count ({$<today()-30={">=$([Current Sales Cycle Activity Date])"} >} distinct [Order Number])

       

      I need to use set analysis as I have some other conditions but just not shown them here.

       

      Any ideas

       

      Many thanks

       

      David