nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert string with date text to date format in BIRT table

pratikgala

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.

Find more posts tagged with

Comments

micajblock

is it always in format MMM dd yyyy?

pratikgala

<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

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

thanks this works beautifully, thanks genius

micajblock

Not a genius just experienced :-)

Sjonneis

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