SSRS Report Builder Part 7.6 - Calculating Date Parts

[@yashsomaiya8141]

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

[@WiseOwlTutorials]

Thanks Yash! Plenty more videos on the list, as soon as I find time to create them!

[@jingzhao5999]

thank you very much, fantastic courses!

[@WiseOwlTutorials]

You're very welcome, glad you enjoyed it!

[@marietteebua9597]

@@WiseOwlTutorials Hi sir your tutorials really helped me…thank you so much! Im new in ssrs and sql, just barely a month and you have been of so much help to me. May I request also if you could show an example of an sql query in getting half of year data so also through expression? My date however is dynamic for the enduser to just input in the date parameter to generate the data…say, if the enduser would input end date 2021/05/31, the data retrieved would be the aggregated 1st half of the year and if she would input end date 2021/12/31 then the data retrieved are aggregated 1st half and 2nd half respectively. Ive been doing research on this but i find no solution at all…All the suggested solutions in the net does not work unfortunately. Really thanks for your immediate reply. I have the quarterly and monthly but cant get the semi annually…So many discussions on this online but all suggestions dont work..i noticed its a hot topic but none provides the right solution…

[@pittwood2791]

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

[@WiseOwlTutorials]

Hi there, there are a few ways to do this. One way is to use the FORMAT function in the SQL query which populates your dataset. You can specify the culture in the third parameter of this function like so: SELECT Title ,ReleaseDate ,FORMAT(ReleaseDate, 'MMMM', 'en-GB') AS UKMonth ,FORMAT(ReleaseDate, 'MMMM', 'de-DE') AS GermanMonth ,FORMAT(ReleaseDate, 'MMMM', 'pl-PL') AS PolishMonth ,FORMAT(ReleaseDate, 'MMMM', 'es-ES') AS SpanishMonth FROM Film You can see a list of cultures in various MS Docs pages, here's one for reference docs.microsoft.com/en-us/openspecs/windows_protocols/ms-lcid/a9eac961-e77d-41a6-90a5-ce1a8b0cdb9c If you only needed to see one language at a time, you could set the report's Language property in the Properties window. to do this, from the ribbon selected View | Properties. Click off the report body so that the word "Report" shows at the top of the Properties window. Find the language property and change this to the culture you need. I hope that helps!

[@pittwood2791]

@@WiseOwlTutorials I was changing language in properties but in wrong place (not for whole report but one cell) and it didn't work. Now it works! Thank you!

[@WiseOwlTutorials]

@@pittwood2791 Excellent! You're very welcome and thanks for letting us know that you got it working!

[@abeybrams2366]

It seems like the Dataset does not have the DOD column. Which column is that?

[@WiseOwlTutorials]

Hi Abey! There's an older version of the Movies database which doesn't include the DoD column. You can find a copy of the version used in this video here kzbin.info/www/bejne/pIfOc6yQbcx-fpY I hope it helps!

[@abeybrams2366]

@@WiseOwlTutorials Thank you so much

[@WiseOwlTutorials]

@@abeybrams2366 No problem!

[@salaiarunmanijb174]

how to sort Month-YY in order

[@WiseOwlTutorials]

Hi! You'll need an expression (either in a calculated field or in the sort expression) which formats the date as YYYYMM and then use this to sort. Hope it helps!

[@jessipinkman7659]

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

[@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 😔

[@WiseOwlTutorials]

Hi! You could concatenate the year and the month together. Or use the Format function to create a custom format for each date: Format(Fields!ReleaseDate.Value, "yyyy-MM") or something similar. I hope it helps!

[@JC-KeepSmiling]

@@WiseOwlTutorials Thankyou! Didn't think I would get a reply. Your videos are SO useful

[@UlysseFrance]

32:28 format date

[@UlysseFrance]

41:33 is nothing

[@chindupriyapavan5044]

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

[@WiseOwlTutorials]

Hello! Did you check out the parts of this video which show you how to calculate the weekday or weekday name? You can use the results of these expressions in filters to return data for the days you're interested in. I hope it helps!

[@simpabar1066]

👍👍