date property in the clipboard page list, group them by like for previous 15 days, 1 month, 1 year, 2 year etc. and count in each group

I have a number of clipboard pages, each page having a date property like birth date, and I need to group them, and count them. Each group, I want to display in the dropdown.


Last Births

in last 15 days  (300)

in last 3 months (700)

the dates are in UTC.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.


Keep up to date on this post and subscribe to comments

May 21, 2016 - 11:01pm

Hi Gyan,

As you say that the date property is available in different clipboard pages, my suggestion would be to write an Activity to fetch all the date property values from the different clipboard pages and then store it in the list then write the java code which can perform your filter to group the results.

Kindly let me know if this suggestion would have helped you.



May 24, 2016 - 5:30am

I dont know why you have this requirement at the first place. But in order to achieve this, you could go one step back. From where these date properties are fetched? They must be getting from the DB or the user form. I think your requirement is from DB. If that is the case, then write a report def to get it directly from those tables. Use join.

May 25, 2016 - 5:25am

I agree to what Rajeev mentioned here.

In case, any specific format of date is to be used, Function Alias in calculation builder of Report Columns should  be helpful.


May 25, 2016 - 6:17pm
Response to dames

thanks but i am trying to group and count then display it in ui

May 26, 2016 - 9:43am
Response to DyanG412


Can you please let us know the version of PRPC being used by you?