Error on validating a Date type attribute.

Error on validating a Date type attribute.

book

Article ID: KB0091608

calendar_today

Updated On:

Products Versions
TIBCO Collaborative Information Manager -
Not Applicable -

Description

Resolution:
Description:
============
Attempting to modify a record with an attribute defined as type date of value 0001-01-01 (YYYY-MM-DD) results in an error:
    GEN-7056: Error converting string Übernahme Datum to date for attribute 1-01-01 00:00:00.

Environment:
===========
All TIBCO Collaborative Information Manager versions.
All platforms hardware and virtual.

Cause:
=====
This is a limitation of the UI.  Internally the date is stored as java Date, which is defined as:
=================================================================================================
A thin wrapper around a millisecond value that allows JDBC to identify this as an SQL DATE value. A milliseconds value represents the number of milliseconds that have passed since January 1, 1970 00:00:00.000 GMT.
=================================================================================================

Resolution:
==========
Be sure all dates are later than January 1, 1970 00:00:00.000 GMT.  If earlier dates are required, a string attribute can be used.

Issue/Introduction

Error on validating a Date type attribute.