Understanding DATEDIFF in SQL Server: Why It Parses Dates as dd/mm/yyyy and How to Correct It

Calculating Time Difference by ID: A Step-by-Step Guide with Base R and Data.table