I think the subject sums this question up. I am in the process of switching from an Access DB to SQL Server for my web based datasource. The things that keep giving me problems are all of my pages that use dates in the SQL. #MyDATE#, Date(), etc...
Also what about Time...
Is there some good posts on here, or resources that describe using Date and Time in SQL Server...or better yet the steps to switch/upsize (concerning dates) from MS Access to SQL Server?