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