Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Date/Time Data Type Provides Current Year Automatically

ACC2000: Date/Time Data Type Provides Current Year Automatically

View products that this article applies to.

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.

↑ Back to the top

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 illustrated this behavior, follow these steps:
  1. Create a new table, as follows:
       Table: DateTable
   --------------------------------
   Field Name: My Date [primary key]
   Data Type: Date/Time
  2. On the View menu, click Datasheet View.
  3. Type 1/1, and then press TAB to leave the field. Note that the value that you entered is displayed as 1/1/<current year>.

↑ Back to the top

Keywords: KB209557, kbhowto

↑ Back to the top

Article Info
Article ID : 209557
Revision : 2
Created on : 6/24/2004
Published on : 6/24/2004
Exists online : False
Views : 256