Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date field & year 2000
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00121590
Message ID:
00121717
Views:
16
>vfp 3.0 win 95
>
>Currently my date field size is set by the
>date field setup of vfp. 07-27-98
>
>Should we be concerned with the format of
>the field? 07-27-98 vs 07-27-1998
>
>Set Century shows four digit year, however
>the actual date field only allows for two digit
>year.
>
>Is the date field format different in newer
>versions of vfp? Does it allow four digit year
>input?
>
>Thanks and have a great day!
>
Becky,

Date fields have always stored the four digit year in the dbf ever since they were introduced in dBASE III. The format stored on the disk is the ANSII standard date format of YYYYMMDD thus the 8 bytes. Your separators are NOT stored on disk.
Previous
Reply
Map
View

Click here to load this message in the networking platform