SSRS Report Builder Part 7.7 - Calculating the Difference Between Dates

By Andrew Gould If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching! Chapters 00:00:00 Topic List 00:00:49 Creating the Basic Report 00:04:16 The DateDiff Function 00:08:46 Calculating Age in Days 00:10:20 DateDiff in SQL 00:16:01 Dealing with Null 00:20:19 Calculating the End Date 00:22:52 Calculating the Difference in Years 00:25:18 Age vs. Difference in Years 00:28:45 Dividing Age in Days 00:32:56 Comparing Month and Days 00:38:01 Shortening the Expression 00:42:15 Using the DateSerial Function 00:47:48 Using the Format Function 00:54:20 Calculating Age in Years in SQL https://www.wiseowl.co.uk - This video explains how to calculate the difference between dates in Report Builder using Visual Basic and SQL. You'll learn how to use the DateDiff function to calculate the difference using different time intervals. You'll also learn how to calculate age in years accurately. If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, VBA, Power BI, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more