>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement