Microsoft KB Archive/286446

= Date/Time data type provides current year automatically =

Article ID: 286446

Article Last Modified on 3/29/2007

-

APPLIES TO


 * Microsoft Office Access 2007
 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q286446



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

For a Microsoft Access 2000 version of this article, see 209557.



For a Microsoft Access 97 version of this article, see 98802.



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



MORE INFORMATION
If your field is assigned the Date/Time data type, and you want to indicate the current year, you do not have to type the year. This feature works for both tables and forms.

To reproduce 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 View. Type 1/1, and then press TAB. Note that the value that you entered is displayed as 1/1/ .

Additional query words: misc date/time inf ACC2002 reviewdocid kbnoOfficeAlertID ACC2007

Keywords: kbinfo kbdatetime kbhowto KB286446

-

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

© Microsoft Corporation. All rights reserved.