Resolution:
Description:
============
When trying to parse the date with the following expression, an error is reported:

tib:parse-date ('EEE dd yyyy','Sep 12 2009') getting
“Input data invalid
caused by: org.xml.sax.SAXException:
com.tibco.xml.xquery.ExprException: Unparseable date:

Environment:
===========
ALL.

Symptoms:
========
Error:

“Input data invalid
caused by: org.xml.sax.SAXException:
com.tibco.xml.xquery.ExprException: Unparseable date:

Cause:
=====
This is caused by an operating system’s regional setting. It might be possible that the date formats specifyed in the expression are not supported by the operating system.

Resolution:
==========
Add following properties in the designer.tra and restart Designer.

java.extended.properties= -Duser.region=US -Duser.language=en

Error parsing date format in the parse-date method of the XPath Formula Builder.