Are the date representations integers or characters? How is a date in 1999 or earlier represented?

Also, it would be nice if you presented your informatioin the way you advocate it in your signature block. Please modify the following to properly represent the problem, and please include some dates from prior to 2000-01-01:

declare @TestData table (

AS400Dates int

);

insert into @TestData

values (1080518),

(1080707),

(1080515),

(1080731),

(1080815),

(1080822),

(1080911),

(1080916),

(1080925),

(1080926),

(1080927),

(1081023);