>>>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 :)