You are confusing two seperate things: formatting and database storage.
There are NO Year 2000 problems with Emerald. The time format used
is accurate to the nearest minute until the year 2079. The display of
a date has nothing to do with the storage of the date. If you need
verification of this, look in your TSQL book under date data types.
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com