>The above problem occurs only when the year of date is entered as 2 digits.
>Am I right?
Yes.
>Does the earlier versions of Foxpro store only 8 digits?
In the dbf file a date is stored always on 8 characters (digits on the format YYYYMMDD). What earlier versions? I am sure that this is like that at least from 2.0.
>Does the 8 digit include 2 slashes(/) also?
No.
>So 02/11/1997 is having 10 digits
>and 02/11/97 is having 8 digits . Am i right ?
>
>I do not find any problem if the 'century is on' while accepting dates from user or system.
Correct. The problem appears only when the user wants to enter the year on 2 digits. This is when you need to use SET CENTURY ... ROLLOVER ... in VFP or a date fix in previous versions.
>If any possible problems or any confusion in my understanding of the above problem, Please enlighten me .
A problem I saw in some wrong designed systems: the date is stored in a character field (on 6 digits or 8 with "/"s) without the 2 digits for the century. It's sure that such a program system can't handle "Y2K", but this is not VFP's fault.
Vlad
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