date parameter in reporting services

Hi
I need to have the following result format into a date time parameter with
the current date
='1/07/2005 5:00:00 AM'
so when i schudule this report to run it will look at the current date at 5a
m.
Thankyou
toddTango
Can you eloborate what you expect
Regards
R.D
"Tango" wrote:

> Hi
> I need to have the following result format into a date time parameter with
> the current date
> ='1/07/2005 5:00:00 AM'
> so when i schudule this report to run it will look at the current date at
5am.
> Thankyou
> todd
>|||my expectation is that when i schedule this report to run it looks at the da
y
at 5am & reports back. All records in my database have a date of at 5am.
so the parameter output should be in datetimeformat showing d/MM/yy h:mm:ss
tt
Thanks
Todd
"R.D" wrote:
> Tango
> Can you eloborate what you expect
> Regards
> R.D
> "Tango" wrote:
>sql

Date

Hi
I need to have the following result format into a date time parameter with
the current date
='1/07/2005 5:00:00 AM'
so when i schudule this report to run it will look at the current date at 5am.
Thankyou
toddFurther to this i have worked out how to get the current date at 5:00:00 AM
which is =format(date.today.addhours (5), "dd/MM/yyyy h:mm:ss tt")
this is outputting what i need in say a text box but i get the error message "
The property default value of default parameter Doesnt have the expected type.
do i need to convert to date time somewhere or something '
Id love to sort this out today if possible.
Thanks
"Tango" wrote:
> Hi
> I need to have the following result format into a date time parameter with
> the current date
> ='1/07/2005 5:00:00 AM'
> so when i schudule this report to run it will look at the current date at 5am.
> Thankyou
> todd|||can anyone help me please :(
"Tango" wrote:
> Further to this i have worked out how to get the current date at 5:00:00 AM
> which is =format(date.today.addhours (5), "dd/MM/yyyy h:mm:ss tt")
> this is outputting what i need in say a text box but i get the error message "
> The property default value of default parameter Doesnt have the expected type.
> do i need to convert to date time somewhere or something '
> Id love to sort this out today if possible.
> Thanks
> "Tango" wrote:
> > Hi
> > I need to have the following result format into a date time parameter with
> > the current date
> > ='1/07/2005 5:00:00 AM'
> >
> > so when i schudule this report to run it will look at the current date at 5am.
> >
> > Thankyou
> > todd