Microsoft KB Archive/98802

= ACC: Date/Time Data Type Provides Current Year Automatically =

Article ID: 98802

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q98802



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
If you enter a partial date in a field formatted with the Date/Time data type, Microsoft Access fills in the current year automatically.



MORE INFORMATION
If your data is formatted with the Date/Time data type and you want to indicate the current year, it is not necessary to type the year. This feature works for both tables and forms.

To illustrated this behavior, follow these steps:

  Create a new table, as follows:

     Table: DateTable Field Name: My Date [primary key] Data Type: Date/Time  On the View menu, click Datasheet. Type 1/1, and then press TAB to leave the field. Note that the value you entered is displayed as 1/1/ 

Additional query words: misc date/time

Keywords: kbinfo KB98802

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.