DateTime Parameters
I have a datetime parameter that is not being passed the full information when I use the Today dynamic text setting. I am unable to change the datetime parameter to a date because it is part of a query in the database. Any ideas how I can resolve this issue?

I'm not very clear what you want... dynamic date: = "2008-09-30" -- = "2008-09-30" Which format do you need?

I have a parameter in a report that requires a DateTime being passed to it in the format: yyyy-mm-dd hh:mm:ss In version 6 I simply passed the dynamic value %Today%:0. This worked fine. It was obviously passing the whole value to the report. When I pass the dynamic value to the parameter and then view the report I am then prompted to select a date.

Hi, I'm using version 7.0.7.0 For your example, is not supported, and try to use , which is "2008-09-30 17:35:52" If you're using version 7.0.7.0, should works for you.

I am afraid that this didn't work. Any other ideas?

Well, it should work... Then, you may create a new blank report with input parameter, say "test", then add to CD, and try the dynamic text from the help file to find one which matches your case....

All of your help is really appreciated and I will try a new report but I am quite sure I have tried the all. The value being passed to the report is simply not a datetime. Problem with MS databases apparently. They don't have a date parameter for queries.