Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inconsistent DATE handling in VFP 6.0
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00206454
Message ID:
00206488
Views:
18
>>Moved to VFP 6.0 because my company was very concerned about being Year 2000 certified. Now my clients have come across some inconsistencies in how VFP 6.0 handles dates.
>>
>>Client enters
>>
>>"02/01/0000" and "02/01/000" are "invalid date".
>>
>>"03/01/0000" and "03/01/000" are valid dates, except on a grid they convert to "03/01/1900".
>>
>>My clients are not happy. Anyone have any info on this?

>Hi Brenda,

>Since there was no year 0, both dates are actually invalid. In the grid's text box control, you might add a check for year 0 and return .F. (preventing exiting the control) if the year evaluates to zero.

Actually, I would have to check for year 0 everywhere BUT in the grid. "03/01/0000" is a valid date everywhere, EXCEPT on a grid. On a grid it converts to "03/01/1900". How would I check for the client entering "03/01/0000" and VFP 6.0 converting it to "03/01/1900"?

Brenda
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform