Question

DateTime x-path

3

When I use this line in x-path: MonthNumber=month-from-dateTime('[%CurrentDateTime%]' It gives me this error 'data type cast needed for parameter or null literal' while I expect for example month-from-dateTime('[%CurrentDateTime%]' to return 2 (current month number).

asked 2011-02-14

Mohammad Fawzy

2 answers

-1

I believe it requires an actual DateTime attribute.

answered 2011-02-14

Robert van 't Hof

Jonathan Veldhuizen · Accepted Answer · 2011-02-14

Probably this is a built-in-database (HSQLDB) only issue. For PostgreSQL, this constraint runs fine. However, you can also create a microflow variable, set the value to the current month and use this variable in the XPath constraint.