>>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.