Date Format for GTC?
645631Apr 27 2009 — edited Jul 1 2009I am reconciling start date and end date using GTC and the values received in the source are of the format: mm/dd/yyyy.
I receive the following error if I specify default format(yyyy/MM/dd hh:mm:ss z) or the format as received from the source - mm/dd/yyyy hh:mm:ss
00:23:52,930 ERROR [SERVER] Class/Method: tcRCE/updateUserField encounter some p
roblems: Unparseable date: "11/13/2006"
java.text.ParseException: Unparseable date: "11/13/2006"
at java.text.DateFormat.parse(DateFormat.java:337)
at com.thortech.xl.dataobj.tcRCE.updateUserField(Unknown Source)
at com.thortech.xl.dataobj.tcRCE.createUserRecord(Unknown Source)
at com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)
at com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
at com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
at com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
at com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
at com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
at com.thortech.xl.dataobj.tcRCE.finishDataReceived(Unknown Source)
at com.thortech.xl.schedule.jms.reconOffline.ProcessOfflineReconMessages
.finishReconciliationEvent(Unknown Source)
Can someone please guide what is the correct format to be specified?
Thanks!