>Cetin,
>
>The datetime value is passed as a double
>If you assign eg 123.45 to loParm.Value and then print loParm.Value, you will see a datetime
>
>Where does it go wrong ? Maybe the format of the double - such that adob thinks that the fractional part ( the seconds ) is invalid en hence zero
Hi Gregory,
I know that internally it is a double but setting it to a double or datetime set the value with time portion, still dropping the time portion in update/inserting into VFP:
loParm.Value = Datetime()
? '1',loParm.Value
loParm.Value = (DATE()-DATE(1899,12,30))+((DATETIME()-CAST(DATE() as datetime))/86400)
? '2',loParm.Value
Both print the same datetime value and both end up with time portion dropped in VFP.
Cetin