3 Replies Latest reply on Nov 22, 2016 4:59 AM by Rashmi Sudhakar

    Show the data for the last day of the quarter

    Rashmi Sudhakar

      Hi,

       

      I need some help in pulling out the data for the last date in the quarter, or if we have not yet reached the quarter we need to pull the data as of the current max date.

       

      For Ex:

       

      if we have the data as below:

       

      to_datecount
      1/31/20165,555
      2/29/20165,491
      3/31/20165,563
      4/30/20165,483
      5/31/20165,457
      6/30/20165,516
      7/31/20165,545
      8/31/20165,645
      9/30/20165,648
      10/31/20165,675
      11/5/20165,683

       

      we need to get the data only for the quarter end, as in get the number for Q1 - march(3/31/2016),Q2 - june(6/30/2016), Q3 - september (9/30/2016), as we have not reached the end of Q4 we need  to pull the data for november(as per the above example).

       

      Could you please help me with the above?