Hello,

We have a custom object (Activation_Step__c ) that tracks the necessary steps (ex: Inventory_Status__c) required to complete an Opportunity.

I am trying to find the completion dates for each of the required steps but so far coming empty handed as I'm getting the overall LastModifedDate for the Object as opposed to the individual steps themselves:

select Opportunity__c, id, CreatedDate, Inventory_Status__c, Contact_Status__c, Payment_Status__c, Contract_Status__c, Activation_DateTime__c, LastModifiedDate   
from Activation_Step__c  

I am new to SOQL, but have decent experience with MSSQL, and theoretically given the fields above, it would have been easy select top 1 subselects. 

Any advice on how to achieve this using SOQL via Workbench?

Thank you in advance! 

Can someone help me with a report formula?  How can I get a net of the PAYMENT - REFUND for each payment type?