SSRS Report Builder Part 7.6 - Calculating Date Parts

By Andrew Gould

Chapters
00:00 Topic List
00:56 The Basic Report
04:39 Calculating Year, Month and Day in Visual Basic
07:34 Calculating Year, Month and Day in SQL
09:32 Calculating Weekday in Visual Basic
12:12 Calculating Weekday in SQL
15:27 Calculating Quarter in Visual Basic
18:03 A Matrix of Months and Weekdays
20:11 Calculating MonthName
24:10 Calculating WeekdayName
27:21 The DateName Function in SQL
29:32 The Format Function
34:31 Dividing Days into Weekdays and Weekends
37:29 Calculating the Decade from a Date
41:50 Calculating Weekends and Decades in SQL
45:39 Fiscal or Financial Month and Quarter
50:43 Fiscal or Financial Year

[yashsomaiya]

Happy to know that you are uploading videos. Please upload videos on Power query, Power Pivot, Power BI and VBA videos on MS Access.

[jingzhao]

thank you very much, fantastic courses!

[JC-KeepSmiling]

The difficulty I always have is where you have a report in SSRS that is showing more than one calendar year or more than one financial year because the months are the same but years different- so I need something that gives Year & Month together for each differentiated Year 😔

[jessipinkman]

Hi Sir, i hope you are doing great ! I need one help, i need extract data from ms access database from excel, with two date criteria, kindly help, how can i change the date into dynamic dates, pls help

[abeybrams]

It seems like the Dataset does not have the DOD column.

Which column is that?

[pittwood]

How to show names of months in other languages - like german, polish, spanish...?

[chindupriyapavan]

Hi Sir,
Please help me to fetch data for Sunday's date.. eg. From last 100 days I just want fetch Sunday's date ..i.e 08/01/2021, 08/08/2021, 08/15/2021, 08/22/2021... And so on
Past 10days I'm struggling to get this please help me