Format-date and Format-date-time xpath functions are not working in BW 6.x .

Format-date and Format-date-time xpath functions are not working in BW 6.x .

book

Article ID: KB0093709

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
In BW5, format-date($Timer/Date,"yyyy-MM-dd") prints "2015-01-13". The same does not work in BW 6.
Symptoms:
Parsing fails and prints nothing.
Cause:
This is caused by the change of the XPath library in BW 6 which uses thr XPath 2.0 specification. XPath 2.0 Converts a date value into human readable format using a "picture string".

Issue/Introduction

Format-date and Format-date-time xpath functions are not working in BW 6.x .

Resolution

Change the format date as follows.  format-date($Timer/Date,"[Y0001]-[M01]-[D01]")

Additional Information

http://www.w3.org/TR/xslt20/#format-date