I can insert records into FoxPro except when the record has a date field.  I
can't figure out what format FoxPro will accept.  I
have tried several different formats including :

insert into Table(ADate) values ( '#1/1/2001 12:30:00 AM#')
insert into Table(ADate) values ( #1/1/2001 12:30:00 AM#)
insert into Table(ADate) values ( '1/1/2001 12:30:00 AM')
insert into Table(ADate) values ( 1/1/2001 12:30:00 AM)

and none of these work and don't know what else to try.

Any help is appreciated................thanku...dick barney

Try to use:

insert into Table(ADate) values ( {1/1/2001 12:30:00 AM})

Regards,

Thanks Gary,

It works perfectly.
 Is this documenented somewhere?  I tried and couldn't find anything.

thanku.........dick barney

Check the SQL ststement syntax of Foxpro for the answer. It can be found
from Microsoft MSDN online documentation at
http://msdn.microsoft.com/library/default.asp.

Regards,

Gary,

I am a VB programmer and the last I saw (and never wrote) any xBase was 10
or 12 years ago. I looked in the the MS Library where you directed and
couldn't find anything on Foxpro SQL dates.  Could you come up with an exact
path - because maybe I am using or searching the library inefficiently.

thanku.........dick barney

Here is the article found in MSDN. Though it doesn't address the problem we
are discussing, we can learn something from the article.

HOWTO: Formatting a Date or Time Value to Query an SQL Table
http://support.microsoft.com/support/kb/articles/Q145/8/17.asp

Regards,

All you need to do, is to use Curly braces around the date value being passed:

   Insert into Table(ADate) values ( {1/1/2001})