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