Rob M.
asked on
SSRS: Date Expression Needed for Previous Business Day with 1 PM Time Stamp
Hello,
I am trying to add a date with a time portion as a parameter default value in SSRS (2016) . The default date needs to be previous business day at 1 PM. The underlying report runs every day and uses this date to look for changes to certain data as of the previous business day at 1 PM.
Example: 2019-01-22 13:00:00.000 or 1/22/2019 1:00:00 PM as i see it formatted when i run the report in SSRS.
Could someone please help with the proper Date Expression?
Thank you in advance.
Rob M.
I am trying to add a date with a time portion as a parameter default value in SSRS (2016) . The default date needs to be previous business day at 1 PM. The underlying report runs every day and uses this date to look for changes to certain data as of the previous business day at 1 PM.
Example: 2019-01-22 13:00:00.000 or 1/22/2019 1:00:00 PM as i see it formatted when i run the report in SSRS.
Could someone please help with the proper Date Expression?
Thank you in advance.
Rob M.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER