Hello I've converted a spreadsheet into a SSRS report which is run on the 20th of month and I need to pass the 20th of the current month as a default value (start date). If the 20th falls on a Saturday, default to friday 19th. If the 20th falls on Sunday default to Friday 18th. How do I do this and what is the best way of doing it?
asked May 31, 2011 at 05:47 AM in Default
Personally, I would handle this within the stored procedure and not try and work this out in SSRS.
This code snippet shows how to determine a startdate according to your rules. Note that in my environment the week starts on a Sunday (i.e.@@DATEFIRST = 7) - if you have a different start to the week you will need to adjust the values.
answered May 31, 2011 at 05:59 AM
Kev Riley ♦♦