[AccessD] ADO Problem

On 28 Nov 2006 at 10:15, Beach Access Software wrote:

> Dear List:
> 
> A colleague (who thinks I know ADO) writes in to ask why the following:
> 
>    Conn.Execute "INSERT INTO tWeeklyUpdateSent ( DateSent ) " & _
>                  "SELECT " & dtToday & ""
> 
> Inserts a record into tWeeklyUpdateSent so the conection is OK.  But but the
> date is 1/1/1900 instead of today´s date.

You are building  a string which looks like:
INSERT INTO tWeeklyUpdateSent ( DateSent ) SELECT 11/28/2006

What you want is:
INSERT INTO tWeeklyUpdateSent ( DateSent ) SELECT '11/28/2006'

so you need to use
 ... "SELECT '" & dtToday & "'"
(note the two single quotes)

-- 
Stuart