Page last updated: October 27, 1998.

Cycla Corporation
Year 2000 Suggestions for Clients

Suggested Client Actions

For clients who maintain systems based on Cycla's Level 5 framework library and methods, the following changes are suggested:

1. If your primary key formats include 2-digit years within the number (e.g., A98D0006), and your users frequently want to sort records by this key field, you can easily revise this scheme by changing the part of the expression that reads RIGHT( m.gn_fy,  2) to instead use:

   	IIF( m.gn_fy < 2000, ;
   		SUBSTR( STR( m.gn_fy, 4), 3, 1), ;
   		CHR( ASC('A') + INT( (m.gn_fy - 2000) / 10))) + ;
   	 RIGHT( STR( m.gn_fy, 4), 1)
   

   This will cause numbers to have a "A0" in 2000, "B0" in 2010, etc., which will allow people to sort on this number and retain chronological ordering. NOTE: This is in no way required to be compliant. Sorting on these numbers seldom has any true meaning, and users can always sort on record creation date, instead.