General information
Title:
VFP6 Date Import Bug
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only