>Thanks Sergey, I've tried those methods. The problem I'm having is that I need to put the date value in a SQL insert string with other values that are actual strings. Below is an example:
>
>FOXSQLINSERT = "INSERT INTO setup (Job_num,Entry_Date, Track)VALUES" _
>+ "('" + Session("JobNum") + "','" + + {^2004/01/12 12:45:00} + "','" + txtTrack.Text.Trim + "','" + "" + " ')"
>
>I am doing this from ADO.NET. Ideas? Thank you
>
Tim,

Try

FOXSQLINSERT = "INSERT INTO setup (Job_num,Entry_Date, Track)VALUES" + _
+ "('" + Session("JobNum") + "', {^2004/01/12 12:45:00},'" + _
txtTrack.Text.Trim + "','" + "" + " ')"