Hello Hifumi,
I would like to add the following information concerning your statement
„I know that 2E date type DT# can be handled until 2199“.Our customers are using 2E Date Type DTE(Internal value : CYYMMDD).”
As a reviewing of the date and time area in 2E took place at the time of Release 5.1 (so more than 20 years ago!), one can of course easily forget that it was with this release that the date range for the DTE field was increased, too. (Not the same range and display as with IBM’s CYMD, of course).
Starting with the mentioned 2E release, the range for the DTE field is the same as for the DT# and D8# fields: From 01.01.1801-31.12.2199.
The century digit is stored in the following way on the file:
Years starting with 18 are stored as a negative value.
Years starting with 19 are stored with 0 (not visibile)
Years starting with 20 are stored with 1.
Years starting with 21 are stored with 2.
You can easily test this by assigning Edit Code “/” or “–“ to a DTE field on the screen to make the year show as four digits, and then see how the different dates are stored on the file according to the rules mentioned above.
You can get more interesting and important information on internal and external formats of the different date field types on the “Defining a data model" User Guide, pages 68-78.
I just wanted to add this, not knowing of course what exactly are your requirements. Also, I saw that you have posted your idea on the idea wall.
Best regards
Anette-Nicole