Convert a string (in date format) to datetime using Javascript

Question

In BIRT, i have a column containing a datetime stored as a string. I need to convert these string to datetime format and put the result in another column using Javascript. The string is the form of: for example: Fri 21 Feb 2014, 09:40 AM.

Hence this when converted to a datetime format and exported to excel, the column should be treat as a date. Can any one of you help me to do it?

Cheers,

Answer 1

Other answers do not take into consideration this question is in a BIRT context.

• Create a computed column in your dataset, with "Date time" as datatype
• Enter as expression:

new Date(row["myDateStringField"]);

Where "myDateStringField" is your DateTime column in a String format. Then use this computed column in your report instead of the String column.

That's it!