Eclipse Community Forums: BIRT

Help

Home

Home » Archived » BIRT » String To Date(String To Date Conversion)

Show: Today's Messages :: Show Polls :: Message Navigator

String To Date [message #1720989]

Fri, 22 January 2016 10:38

JP Redro

Messages: 181
Registered: July 2009
Location: India

Senior Member

Hi All,

I am using BIRT 4.3.1, and while developing report we have an issue with Date, which is in string.

We are using XML as data source and the date in one tag which consists of another strings too. We have to split the string and convert into date. below is the example string.

<REF>Cash: CC1183MC-10/14/15: 700.00</REF>

We have to get the 10/14/15 in the form of 14-OCT-2015. Please suggest me.

FYI,
I have tried with the following approach but no luck.

Step1: split computed column
(row["REFERENCE"].substr(10, Cool

).replace(":","")

Step 2: converting into Date
importPackage( Packages.java.text );
new Date((row["Ref_Date"]), "dd-MMM-yyyy");
Result is : 1970-01-01

Actually we have to get it as 14-OCT-2015.

Thanks & Regards
JP

Thanks,
JP

Report message to a moderator