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

    Set analysis using start and end dates

    Vijay Jagjivan



      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.