I have a group of items that's being created in a rule and its format is lik

aswinb over 11 years ago

I have a group of items that's being created in a rule and its format is like this:

[month = 3, year = 2013, number = 1],
[month = 3, year = 2013, number = 1],
[month = 3, year = 2013, number = 1],
[month = 3, year = 2014, number = 1],
[month = 3, year = 2014, number = 1],
[month = 4, year = 2014, number = 1],
[month = 4, year = 2014, number = 1]

I would like to get the count of the field 'number' that were created in the same month and same year. For instance if the month = 3 and year = 2014, I would like to get the count of the 'number' field for those dates. Any help would be deeply appreciated.
thanks...

Discussion posts and replies are publicly visible

Parents

0 aswinb over 11 years ago

Yes Jesse, I am trying to do this dynamically for each month in different years and so a monthOfInterest and yearOfInterest can't be provided. There will be two given sets of dates and between those I have to count the number of items that were created each month and in each year that happens between the time intervals that the user selects.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aswinb over 11 years ago

Yes Jesse, I am trying to do this dynamically for each month in different years and so a monthOfInterest and yearOfInterest can't be provided. There will be two given sets of dates and between those I have to count the number of items that were created each month and in each year that happens between the time intervals that the user selects.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data