Convert string with date text to date format in BIRT table

pratikgala · June 12, 2015

I have a Date which I retrieve as a string "Dec 20 2007" from my front end app and insert into a BIRT table.
 
Since the data type for this field is set as "Type: String" when I convert it to Date the table breaks and no data is visible in the Table. 
 
My ultimate goal is to sort the table by Date. 
 
Any solution to convert the string which is "Dec 20 2004" to date format in BIRT table. 
 
Thanks.

micajblock · June 12, 2015

is it always in format MMM dd yyyy?

pratikgala · June 12, 2015

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="137059" data-time="1434126432">
<div>
is it always in format MMM dd yyyy?
</div>
</blockquote>
Yes it is always in that format.

micajblock · June 12, 2015

Is is very simple, simply create a new data item with an expression like this:
<pre class="_prettyXprint">
new Date(row["String Date"])</pre>
Then you can sort on the new data binding. See attached example.

pratikgala · June 12, 2015

thanks this works beautifully, thanks genius

micajblock · June 12, 2015

Not a genius just experienced :-)

Sjonneis · June 26, 2023

How can I see the image? Its not working for me.

Convert string with date text to date format in BIRT table

Comments

Categories