>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