SSRS Report Builder Part 7.7 - Calculating the Difference Between Dates

By Andrew Gould

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

[chindupriyapavan]

Thanks alot for detailed information Sir!!! You have excellent teaching skills❤️💯

[mae]

Thanks Sir! Pls show also YTD this year vs YTD last year of the same month and day but is dynamic, that means if the end user would select the end date parameter May 29, 2022, then I can get the total from January to May 29, 2022 and my last Year YTD is also January to May 29 last year that is 2021..
Right now my query would able me to get YTD but my last Year would be up to whole month of May instead of only until May 29. Thank you so much!

[nizamdeen]

How to get average HH:mm:ss using SSRS

[chindupriyapavan]

Hi Sir,
How to find lastdayoftheweek from month, let's say for one month has 4 Sunday's and want to show Sunday's date in matrix table. Please help me on this

[Swanny]

Thank you for this! Is there a way to display DateDiff as Day's and hours and not one or the other?

[tirumalabalaji]

Hello Sir,

Please explain how to filter Hours from last 35days.... if we want to filter 06PM To 9PM data from Historical dates