2 Replies Latest reply: Feb 28, 2013 10:15 AM by Gysbert Wassenaar RSS

    Set analysis using start and end dates

    Vijay Jagjivan

      Hi,

       

      i am using this in an expression to count the number of records received from 01/01/2013 to 31/01/2013 inclusive. the result should be 97 but it only returns 93 and ignores all records that are for 31/01/2013.

       

      count({$<[CMS Entered Date]= {'>=01/01/2013<=31/01/2013'} >} [CMS Entered Date])

       

      please advise where i am going wrong.

       

      thanks

       

      vijay