>>>>
>>>>Are you really sure about the number 9051840 as a representation of {^2005-03-18}?
>>>
>>>Well it all displays ok when i run your code.
>>>
>>>Yes, i am sure about the representation for that date with the number 9051840 ( the string to be exact ).
>>
>>Can you give a few other paired examples of this discrepancy between SQL dates and their VFP values?
>
>
>9286560 --> 28/8/2005
>9329760 --> 27/9/2005
>9280800 --> 24/8/2005
>9324000 --> 23/9/2005
Now that i put them all together i see those numbers represent minutes.
From 23 to 27 september, that's 4 days represented by 5760, that's 1440 / day, then number of minutes per day
Why do programs stop working correctly as soon as you leave the Fox?