Date and Time Parameter:

I have a report that I will use a DateCreated value for the date and time
parameters. The time stamp for the DateCreated value does carry dates and
times. This report is for three 12 hour shifts and the hours run from 7:00
PM to 7:00 AM. I need to set my default parameters to display as yesterday's
date with the time of 7:00 PM and today's with the time of 7:00 AM. How do I
write this in my sql and set my defaul parameters? Please help! Thanks,
Deborah
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200604/1Well you could base your paramter on a stored procedure which returns
yesterdays date.
"Deborah via SQLMonster.com" wrote:
> I have a report that I will use a DateCreated value for the date and time
> parameters. The time stamp for the DateCreated value does carry dates and
> times. This report is for three 12 hour shifts and the hours run from 7:00
> PM to 7:00 AM. I need to set my default parameters to display as yesterday's
> date with the time of 7:00 PM and today's with the time of 7:00 AM. How do I
> write this in my sql and set my defaul parameters? Please help! Thanks,
> Deborah
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200604/1
>