SSRS 2008 PARAMETER LAST SATURDAY OF MONTH
I need the parameter in SSRS to return the last Saturday of the month based upon today's date.
Cheers,
November 10th, 2010 6:17pm
Hello, using this expression should work:
=iif(weekday(dateserial(year(today), month(today)+1, 0)) = 7,
dateserial(year(today), month(today)+1, 0), dateserial(year(today), month(today)+1, 0 -
(weekday(dateserial(year(today), month(today)+1, 0)))))
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2010 7:28pm
This topic is archived. No further replies will be accepted.
Other recent topics
