SSRS: Date Expression Needed for Previous Business Day with 1 PM Time Stamp

Rob M.
Rob M. used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
For the 'previous business day' aspect of this question you can check out my article SQL Server Calendar Table, download the code, alter it to match your definition, and run it.  Then you'll always be guaranteed to get the correct business day taking into consideration weekends and holidays.

Author

Commented:
Thanks. This is very useful. Appreciate the response.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial