AcuXDBC gives wrong date for year-month date format


This article explains what to do when AcuXDBC gives the wrong date for a date mask that specifies only the year and month, YYYYMM.


AcuXDBC supports incomplete date types. This feature is documented in Section 3.3.4 of the AcuXDBC User’s Guide as:

"It is sometimes desirable to have incomplete date types, for example to have YYYYMM to simply store the year and month. AcuXDBC defaults the month and day to 1, so that incomplete types will be valid. Note that AcuXDBC can handle incomplete date types, but if you have a complete type and invalid date data, AcuXDBC cannot handle the date."

However, if only a partial date mask is specified, the unspecified portion does not default to the correct value. For example, with a date mask of YYYYMM and data of 200810, the field might assume the value 2008-OCT-00 (which is not a valid date) instead of the correct value of 2008-OCT-01.


This is a known issue and has been fixed in Version 8.1.1. Upgrading to 8.1.1 is the only known resolution.

Old KB# 14468
Comment List
Related Discussions