HSI_guelph
asked on
Need help setting end date in SSRS
I am using parameters to set the start and end dates of our business week with this code:
I need the end date to be 11:59:59 AM. I can't set the end date to September 17th at midnight because hours for the 17th are clocked in at 12:00:00 AM (database set up by outside company). I'm generating the dates dynamically, can anyone help me fix the end date please?
=DateAdd("d", -7 -(WeekDay(Today(),2))+1, Today())
gives me 9/10/2012 12:00:00 AM=DateAdd("d", -1 -(WeekDay(Today(),2))+1, Today())
gives me 9/16/2012 12:00:00 AMI need the end date to be 11:59:59 AM. I can't set the end date to September 17th at midnight because hours for the 17th are clocked in at 12:00:00 AM (database set up by outside company). I'm generating the dates dynamically, can anyone help me fix the end date please?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER