Date Selector CCE Format issues

Prakash_Nathan

Hello

Please let me know the format of the date to be used, while we set the value for Date Selector CCE widget, using APIs.

Following attempt fails..
mo.setAttributeValue("Discontinued_From", "11/11/11");
java.sql.SQLException: [SQLState=22008][ErrorCode=1843]ORA-01843: not a valid month

mo.setAttributeValue("Discontinued_From", "2011-12-30 00:00:00.0");
java.sql.SQLException: [SQLState=22008][ErrorCode=1861]ORA-01861: literal does not match format string

Thanks
Prakash

Mario_DAnna

You have to provide a Date instance as the argument of the setAttributeValue.

ciao

Mario

 

From: eLink Entry: Discussion Group - Web Experience Management [mailto:v7webcontentmanagement@elinkkc.opentext.com]
Sent: Wednesday, December 07, 2011 2:33 PM
To: eLink Recipient
Subject: Date Selector CCE Format issues

 

Date Selector CCE Format issues

Posted by prakash.nathan@hrblock.com (Nathan, Prakash) On 12-07-2011 08:27

 

Hello Please let me know the format of the date to be used, while we set the value for Date Selector CCE widget, using APIs. Following attempt fails.. mo.setAttributeValue("Discontinued_From", "11/11/11"); java.sql.SQLException: [SQLState=22008][ErrorCode=1843]ORA-01843: not a valid month mo.setAttributeValue("Discontinued_From", "2011-12-30 00:00:00.0"); java.sql.SQLException: [SQLState=22008][ErrorCode=1861]ORA-01861: literal does not match format string Thanks Prakash

---

[To post a comment, use the normal reply function]
Forum:	Discussion Group - Web Experience Management
Content Server:	Knowledge Center