I need a subtraction of a max date to the last previous status date and cannot figure it out. I will be using FindingID and UpdatedEstimatedRemediationDate.
FindingID 'FND-5645' has been updated 3 times:
I need to get the days difference from June 30, 2016 from December 12,2015. I am using SQL Server 2008 R2. Thanks in advance.
where FindingID= 'FND-5645'
group by findingid;
but it only gives me the MIN and MAX, not the two most recent days.