SPR

Technote

SPR# TNAA5DXF8L - Fixed the column setting for displaying the year in a view column which only displays Month & Year. This regression was introduced in 6.0.

Notes R6 clients viewing R5 or R4 databases that either default to showing a 4 digit year for 21st century (R4) or have explicitly set this setting (R5) and have view columns defined to use the user display (OS setting) and are set to show the year/month only (not year/month/day) will see a difference in the number of digits used to display the year because R6 will not pick up the 'show 4 digit year for 21st century ' setting for this particular column. Thus, to encounter this issue, the situation must be:
- User has R6 client looking at R5 or R4 database
- Database view has a date column set to use a year/month format
- If R5, date column is set to show 4 digits for 21st century. (R4 defaults does not have an explicit setting)
- Database view column is also set to use the User's settings for display
As a result, instead of seeing 2002 for the year, the R6 client will display 02 for the year.


Last Modified on 11/11/2002