General information
Category:
Coding, syntax & commands
>>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
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