I developed my website using Access and the db was upsized to SQL Server 7.0 prior to going live.<BR><BR>Access used to be able to INSERT the string "17-August-2001" into a Date field.<BR><BR>It seems SQL Server is having problems with accepting the string. Is there a prefix or suffix that I add to the string to make it acceptable to SQL Server?<BR><BR>Cheers, Alfred Low.