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