Hello all,
I am currently working on an ASP application that pulls a date field of smallDateTime type from an MSSQL database. In SQL, the date appears correctly, but when I use a recordset in ASP to access the date and display it, I keep getting 12/30/1899. Does anyone have any ideas as to why this is happening and what I can do to correct this? Thanks! :)

Can you post your code?

Dave,

I just fixed this problem today and I'm not sure why. Initially, I was doing a SQL JOIN statement to retrieve the date and I was explicitly naming table fields to return. When I change the SELECT statement to "SELECT *" instead of naming the fields, all of a sudden the date was being read correctly in my ASP page.

Thanks,
Chris