3 Replies Latest reply: Dec 14, 2012 6:06 AM by niranjan RSS

    Need help in set analysis

    Sushil Kumar

      Hi All,

       

      In my application i need to get count of data for the lastday of the selected month.

       

      i have a Date field which contains Date with time stamp. i have taken that Date field in listbox and there i have set an expression "=monthname(Date)" to get only month name in the list box.

       

      Now if i select Oct 2012, i should get count of DATA for 31-Oct-2012 in the chart. in my sample data it should be 39.

       

      i have attached the sample application and sample data file for clear understanding.

       

       

      Please help me out to solve this problem.

       

       

      Thanks

       

      SKR