4 Replies Latest reply on May 19, 2017 6:41 AM by Maurice Esperanza

    Looking to get the number of records for the last day of each month

    Maurice Esperanza

      For the example below I would like to just get the number of records for 7/31/2016 = 130 and 8/31/2016  = 161

       

      DateNumber of Records
      7/1/2016100
      7/2/2016101
      7/3/2016102
      7/4/2016103
      7/5/2016104
      7/6/2016105
      7/7/2016106
      7/8/2016107
      7/9/2016108
      7/10/2016109
      7/11/2016110
      7/12/2016111
      7/13/2016112
      7/14/2016113
      7/15/2016114
      7/16/2016115
      7/17/2016116
      7/18/2016117
      7/19/2016118
      7/20/2016119
      7/21/2016120
      7/22/2016121
      7/23/2016122
      7/24/2016123
      7/25/2016124
      7/26/2016125
      7/27/2016126
      7/28/2016127
      7/29/2016128
      7/30/2016129
      7/31/2016130
      8/1/2016131
      8/2/2016132
      8/3/2016133
      8/4/2016134
      8/5/2016135
      8/6/2016136
      8/7/2016137
      8/8/2016138
      8/9/2016139
      8/10/2016140
      8/11/2016141
      8/12/2016142
      8/13/2016143
      8/14/2016144
      8/15/2016145
      8/16/2016146
      8/17/2016147
      8/18/2016148
      8/19/2016149
      8/20/2016150
      8/21/2016151
      8/22/2016152
      8/23/2016153
      8/24/2016154
      8/25/2016155
      8/26/2016156
      8/27/2016157
      8/28/2016158
      8/29/2016159
      8/30/2016160
      8/31/2016161