DateTime Parameters

kitmancraig · Posted: Mon Sep 29, 2008 4:50 am Post subject: 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?

pockeyfan · Posted: Mon Sep 29, 2008 7:55 pm Post subject:

I'm not very clear what you want...

dynamic date: [ymd] = "2008-09-30"
[y]-[m]-[d] = "2008-09-30"

Which format do you need?

kitmancraig · Posted: Tue Sep 30, 2008 2:30 am Post subject:

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 [Today] dynamic value to the parameter and then view the report I am then prompted to select a date.

pockeyfan · Posted: Tue Sep 30, 2008 3:34 am Post subject:

Hi, I'm using version 7.0.7.0
For your example, [today] is not supported, and try to use
[ymd][T], which is "2008-09-30 17:35:52"

If you're using version 7.0.7.0, [ymd][T] should works for you.

kitmancraig · Posted: Tue Sep 30, 2008 4:12 am Post subject:

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

pockeyfan · Posted: Wed Oct 01, 2008 7:58 pm Post subject:

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....

kitmancraig · Posted: Thu Oct 02, 2008 1:28 am Post subject:

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.