Gary Kjos
garykjos at gmail.com
Tue Nov 28 12:33:40 CST 2006
Don't know DAO at all but don't you usually have # signs around dates in SQL statements to mean Date Format enclosed. GK On 11/28/06, Beach Access Software <bchacc at san.rr.com> 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. > > I had him check the contents of dtToday and it does indeed have 11/28/2006 > in it. > > Does anyone see what he's doing wrong here? > > > MTIA > > Rocky > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com