| External Report Parameters and TimeDate parameters [message #44488] |
Wed, 08 June 2005 09:59  |
Eclipse User |
|
|
|
Originally posted by: itsupport.millwood.uk.com
Hi All
Great product.
I am trying to do a couple of things and as I am new to this it is proving
difficult.
I am trying to place a TimeDate parameter into the query. I have
successfully added parameters for the a string property which it then uses
for the query where clause, but when I try to pass through a time date
value, when passing the value from the report parameter to the data set
parameter, it cannot convert the data to a java date object, and gives out a
cast error (e.g. cannot create date object please use this format ......), I
am using the short date format for entering in (e.g. 7/5/05). P.S I am in
the English timedate format.
thanks for any help,
James
|
|
|
|
|
| Re: External Report Parameters and TimeDate parameters [message #47905 is a reply to message #44945] |
Sat, 18 June 2005 03:13  |
| Eclipse User |
|
|
|
Originally posted by: ejo.USUNo2.pl
I have the same problem
is there any solution for passing date to a sql query ?
"nate custer" <ncuster3@hotmail.com> wrote in message
news:687f79472db3311edb3b6bc7f32b2a16$1@www.eclipse.org...
> i've had the same issue, but i approached it differently. i made my
> parameters in the query portion of type DateTime, and as a default value
> put in "new Date()", and that fails when trying to use the default values
> in the query. i also bound two user-supplied parameters (of type
> DateTime) to the query parameters and the same issue, it can't create a
> date. i entered in the dates to use as "01/30/2005 00:00:00 AM" which is
> what BIRT/report-designer says to use as date constants, and it still
> doesn't work. anyone else have an idea on this?
>
|
|
|
Powered by
FUDForum. Page generated in 0.06392 seconds
Home