Tansfer Dates to SQL Server

[Guest]

I'm trying to transfer dates Via ADO to SQL Server. It won't take ## signs
around the date in an insert, so I removed them. But now all the dates read
10/01/1900 in SQL Server. Should I use some date function or send it as a
string with apostrophes wrapped around it?

Jim Stiene
(e-mail address removed)

 

[Duane Hookom]

Try apostrophes with ADO and SQL Server.

 

[Guest]

Thanks. That works great.
(e-mail address removed)