Help on calculating the biggest difference between dates
I have one table with the following data:
I need to extract the biggest difference between two dates per Unit and store on another data table, like this:
If there's only one event for a given Unit, the difference must be calculated between today and the date of that event. There will be at least one event per Unit on the table.
Can you guys help me on that? Any idea?
Thanks in advance!