Data deployment issue with Date format

msr

Hi,

Iam deploying the content to the target enveronment and database synchroniously.Iam getting problem with Date format.I have given date format as '(column name="FILE_DT" data-type="DATE" value-from-field="TeamSite/Metadata/FILE_DT" data-format="MM/dd/yyyy" /)'.
Iam setting the FILE_DT field value using set extended attribute.

This FILE_DT field is having different formats in different files.If the format is MM/dd/yyyy deploying the content is successful.For other formats(like yyyy/dd/MM or yyyy-dd-MM), getting deployment failure.
Iam getting following error:
DBD: ERRORimpleDateFormat.parse() could not parse the string '2008-01-02' with format: MM/dd/yyyy

Please suggest me to resolve the issue.

TS--6.5
OD--6.1.1
DD--6..1.1
DB2 database.
DD standalone

Thanks in advance.
mSR

Adam Stoller

Hi, Iam deploying the content to the target enveronment and database synchroniously.Iam getting problem with Date format.I have given date format as '(column name="FILE_DT" data-type="DATE" value-from-field="TeamSite/Metadata/FILE_DT" data-format="MM/dd/yyyy" /)'. Iam setting the FILE_DT field value using set extended attribute. This FILE_DT field is having different formats in different files.If the format is MM/dd/yyyy deploying the content is successful.For other formats(like yyyy/dd/MM or yyyy-dd-MM), getting deployment failure. Iam getting following error: DBD: ERRORimpleDateFormat.parse() could not parse the string '2008-01-02' with format: MM/dd/yyyy Please suggest me to resolve the issue. TS--6.5 OD--6.1.1 DD--6..1.1 DB2 database. DD standalone Thanks in advance. mSR

Wasn't this posted before in the last couple of days?
The answers are: