Thanks Sergey
Gerard


>SET CENTURY is irrelevant in this case

>lcDateTimeNow = DATETIME()
>Insert Into MyTable (MyDateTimeFiled) Values (lcDateTimeNow )
>

>
>>I want to store the current Datetime from within a foxpro prg to a Sql Server dattime field
>>
>>i.e. Insert Into MyTable (lcDateTimeNow) Values (MyDateTimeFiled)
>>
>>MyDateTimeField is a DateTime field in the Sql Server Table
>>
>>
>>What do I puit into lcDateTimeNow
>>is it lcDateTimeNow = DateTimeNow()
>>Do I need to have Set Cent on
>>