How to include a datetime parameter within a stored procedure along with string query?

Published --