I am using parameters to set the start and end dates of our business week with this code:
=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 AM
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?