Link to home
Start Free TrialLog in
Avatar of carlosmonte
carlosmonteFlag for United States of America

asked on

Group records with custom yearly grouping

Hi Experts,

I am creating a report where I need to group records yearly but it needs to depend on a specific date.
More in detail, my report is pulling employee records for their hours paid.
I need to show a total of hours paid yearly on the date he/she was hired

So if an employee was hired on 7/1/2010 then it needs to group and total as follows:

Range                                    Total hours paid
======                                  ===============
7/1/2010 - 6/30/2011                    456
7/1/2011 - 6/30/2012                    789
7/1/2012 - 6/30/2013                  1012

If you could guide me to the proper grouping formula I need to create I would really appreciate it

Thank you

CRM
Avatar of Mike McCracken
Mike McCracken

How many years are you looking to see?

mlmcc
Avatar of carlosmonte

ASKER

since the employee started, so date of hire
if they started in 1999 then from 1999 to today
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Seems to be working perfectly :)
I will test thoroughly and get back to you asap

Thanks!
CM
I've requested that this question be closed as follows:

Accepted answer: 500 points for mlmcc's comment #a39291633

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
The solution has worked great.
Thank you mlmcc!