>>>>I am not sure if this is known or not, but I think I found a serious bug in VFP6 (or I'm just doing it wrong). When importing an SDF (text) file with a date in a MM/DD/YY format, VFP6 interprets a date like "01/01/99" as "01/01/0099" when viewed after import with CENTURY on. VFP5 and FoxPro 2.x do not exibhit this behavior and import the date properly as "01/01/1999".
>>>>
>>>>I have tried playing with STRICTDATE (all settings) and CENTURY and nothing seems to effect it's behavior.
>>>>
>>>>To recap:
>>>>
>>>>I am importing a text file with dates that read "MM/DD/YY" with VFP6. These dates are being imported to date fields within the table, but are being interpreted as "MM/DD/00YY" by VFP6. VFP5 and Fox 2.x work fine...
>>>>
>>>>Any work-arounds for this?
>>>>
>>>>Thanks....
>>>>
>>>>-Matt Gordon
>>>Matt,
>>>Quickest could be :
>>>replace dDate with gomonth(dDate, 1900 * 12) for year(dDate) = 0
>>>Cetin
>>
>>Make that for int(year(dDate)/100) = 0
>>
>>:)
>>Rich.
>Hi Rich,
>I should keep my mouth shout when :
>1) It's friday
>2) Have a great tendency to fix HP designjet (+ JetDirect card) with a hammer.
>Cetin :)
Hey Cetin,
If you keep your mouth shut we'll sure miss all your help!
Rich.