5 Replies Latest reply: Mar 1, 2017 11:00 AM by Sunny Talwar RSS

    Count Ids for Max Month

    Bobby Flake



      I have a simple problem and can't seem to work it out.  I have a table that has [CW ID] and a month value.  The data is updated once at the beginning of the month with the previous month's data which means that from March 1 until April 1 the table will only contain data up to and including Feb and on April 1 the March data comes in.


      I am trying to do a count of [CW ID] but only for the mac month in the data and can't seem to get the code working.