Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
0

Questions
1

Replies

I have a problem I don’t know how to solve and hoping someone can help. I have an object which is a services log for clients that have had services. The service log contains customer ID, date of service, type of service, etc.
I need to create a list of unique client IDs who have had services last month for the first time in the current fiscal year. I have to run this on a monthly basis so dates can't be hardwired.
Hopefully someone has a brilliant solution. Thank you.

Steven Houghtalen
December 16, 2016
Like
0

How to create list (using apex) of clients with first time services in current fiscal year