Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 Date Import Bug
Message
 
To
24/05/1999 10:35:33
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00222044
Message ID:
00222055
Views:
30
Have you tried setting up the ROLLOVER year using SET CENTURY command.

>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
- Jayesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform