How to Aggregate DateTime Differences
Scenario Transactional product tables often have multiple date columns that need to be compared and aggregated. Many reports will require the average time between dates to track the overall progress, for example a customer transaction table might have the following date fields: · “purchase_date” · “ship_date” ·…
