Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Year 2000- 2 digit year entry
Message
 
 
To
30/12/1997 16:21:19
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00068469
Message ID:
00068490
Views:
28
>>>>>>I have created a UDF which allows the entry of 2 digit
>>>>>>dates past 1/1/2000. Is this of any value? Have others
>>>>>>created such functions?
>>>>>>
>>>>>>
>>>>>>Ken Wardwell
>>>>>
>>>>>Ken,
>>>>> Does it handle 2/29/2000??
>>>>>
>>>>>Thanx!
>>>>>
>>>>>Tony Miller
>>>>>Vancouver, Wa
>>>>
>>>>Yes it handles 2/29/2000. and it is Fox 2.6
>>>
>>>Are you traeting the input as a Non-date input?? It was my understanding that everything in Foxpro before 5.0 would bomb on a date of 2/29/2000, since 2000 is a Leap Year, but is not a normal leap year..
>>>
>>>Thanx!
>>>
>>>Tony Miller
>>>Vancouver, Wa
>>
>>Tony:
>>
>>Are you referring to a leap year rule that not all century dates (e.g., 2000, 2100) have a Feb 29? Feb 2000 does have 29 days, but Feb 2100 only has 28 days. I think the rule is that if the century year is evenly divisible by 400, Feb has 29 days. i.e., 2000 is divisible, but 2100, 2200 and 2300 are not. If you try testing in VFP, you will find this to be true. ctod("02/29/2100") is not a valid date, as is for the years 2200 and 2300. Thus the exception to the 4-year rule.
>
>Mark,
> So this is still a problem in VFP 5??
>
>Thanx!
>
>Tony Miller
>vancouver, Wa

It is not a problem in VFP 3/5. {02/29/2100} is not a valid date in VFP or anywhere else. VFP follows the 400 year rule.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform