>I don't know if any of you ever thought about this or even got prepared for it:
>
>Set Century On
>? CToD("10/10/2000") && 10/10/2000
>Set Century Off
>? CToD("10/10/2000") && 10/10/00
>Set Century On
>? CToD("10/10/00") && 10/10/1900
>
>After you try this, you'll wish that the japanese guru was right about the year ending before XXI century...
>
>I realize that most of us use CENTURY OFF because it's easier to input data, but within just 4 years I think we'll all be in trouble because of that.
>Comments?

the problem is that even if u SET CENTURY ON and have a four digit space for the year, and a user will key in 2 digits FP will still add 1900 automatically!!!

that means that u can't trust VFP and u should get date field via an object

what I use btw is a Date spinner and a datetime spinner (u can see one of them in last month VFUG newsletter), I have enhanced it since then but even as it is published it is nice (IMHO of course ;) )


Arnon