carlosmonte
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
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
ASKER
since the employee started, so date of hire
if they started in 1999 then from 1999 to today
if they started in 1999 then from 1999 to today
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Seems to be working perfectly :)
I will test thoroughly and get back to you asap
Thanks!
CM
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.
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.
ASKER
The solution has worked great.
Thank you mlmcc!
Thank you mlmcc!
mlmcc