Convert String Date to Date in BIRT3.7.1 [message #800726] |
Fri, 17 February 2012 12:00 |
|
Hi All,
While developing a report in BIRT 3.7.1, i am getting error in Date column(String), which is from XML DB. I have tried with the following scenarios but no luck.
<VALUE-OF format="MMM-dd-yy" >dataSetRow["date"]</VALUE-OF>
df = new Packages.java.text.SimpleDateFormat("dd-MMM-yy");
myDate = df.parse(row["date"].value);
myDate;
Kindly suggest me.
Error Message as:
org.eclipse.birt.data.engine.core.DataException: Fail to compute value for computed column "date".
A BIRT exception occurred. See next exception for more information.
There are errors evaluating script "df = new Packages.java.text.SimpleDateFormat("dd-MMM-yy");
myDate = df.parse(row["date"]);
myDate;":
Thanks,
JP.
Thanks,
JP
|
|
|
Re: Convert String Date to Date in BIRT3.7.1 [message #801017 is a reply to message #800726] |
Fri, 17 February 2012 20:27 |
|
JP
Can you post an example value of dataSetRow["date"]?
Jason
On 2/17/2012 7:00 AM, JP Mising name wrote:
> Hi All,
>
> While developing a report in BIRT 3.7.1, i am getting error in Date
> column(String), which is from XML DB. I have tried with the following
> scenarios but no luck.
> <VALUE-OF format="MMM-dd-yy" >dataSetRow["date"]</VALUE-OF>
>
> df = new Packages.java.text.SimpleDateFormat("dd-MMM-yy");
> myDate = df.parse(row["date"].value);
> myDate;
>
> Kindly suggest me.
>
> Error Message as:
> org.eclipse.birt.data.engine.core.DataException: Fail to compute value
> for computed column "date".
> A BIRT exception occurred. See next exception for more information.
> There are errors evaluating script "df = new
> Packages.java.text.SimpleDateFormat("dd-MMM-yy");
>
> myDate = df.parse(row["date"]);
>
> myDate;":
>
> Thanks,
> JP.
|
|
|
Powered by
FUDForum. Page generated in 0.02914 seconds