Product Summary
Product: 3D Movie Maker	Version: 1.0	Category:Compliant
Language: English	OS: 32-Bit Win	Release Date: 31 Jul 1995
Operational Range:	-
Prerequisites:	none
Product Dependencies:	Windows 95, Windows 98, Windows NT 4.0, Internet Explorer
Clock Dependencies:	none
Last Updated:	29 Sep 1999
Product Details
How the product handles dates: User files are the only data saved, and dates may not be read from or written to these files. There are dates associated with the creation and modification of user files but these are handled by the operating system only. Two-digit shortcut handling: Not Applicable Recommendations: See Internet Explorer compliance documents for information on necessary software updates or install the latest version of Internet Explorer from http://www.microsoft.com/ie.

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Not Compliant
Language: Arabic	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 100 - 31 Dec 9999
Prerequisites:	none
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	22 Apr 1999
Product Details
Why is the product not compliant? Microsoft Access 2.x interprets dates entered with an abbreviated year format to mean the 1900s. That is, the dates 1/1/00 through 12/31/99 are interpreted as 1/1/1900 through 12/31/1999. As a result, you must enter all 4-digits of the year for Access 2 to interpret the date as being in the 2000s. Recommendations: Problems may be avoided by consistently enforcing a long date format (4-digit years) for entry and display. An upgrade to Microsoft Access 95 (version 7.0) or Microsoft Access 97 (version 8.0) is recommended for those for whom the above solution is not sufficient. Description of how the product handles dates: Storage. Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting. Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. 2-digit shortcut handling: Microsoft Access 2.x interprets dates with an abbreviated year format in the following way. 1/1/00 through 12/31/99 are interpreted as 1/1/1900 through 12/31/1999 Common date usage errors: Using the Short Date Input Mask will limit your users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years               Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Not Compliant
Language: Chinese - Traditional	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	none
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	22 Apr 1999
Product Details
Why is the product not compliant? Microsoft Access 2.x interprets dates entered with an abbreviated year format to mean the 1900s. That is, the dates 1/1/00 through 12/31/99 are interpreted as 1/1/1900 through 12/31/1999. As a result, you must enter all 4-digits of the year for Access 2 to interpret the date as being in the 2000s. Recommendations: Problems may be avoided by consistently enforcing a long date format (4-digit years) for entry and display. An upgrade to Microsoft Access 95 (version 7.0) or Microsoft Access 97 (version 8.0) is recommended for those for whom the above solution is not sufficient. Description of how the product handles dates: Storage. Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting. Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. 2-digit shortcut handling: Microsoft Access 2.x interprets dates with an abbreviated year format in the following way. 1/1/00 through 12/31/99 are interpreted as 1/1/1900 through 12/31/1999 Common date usage errors: Using the Short Date Input Mask will limit your users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years               Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: Czech	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: Danish	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: Dutch	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: English	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: Finnish	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: French	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: German	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Not Compliant
Language: Hebrew	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	none
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	22 Apr 1999
Product Details
Why is the product not compliant? Microsoft Access 2.x interprets dates entered with an abbreviated year format to mean the 1900s. That is, the dates 1/1/00 through 12/31/99 are interpreted as 1/1/1900 through 12/31/1999. As a result, you must enter all 4-digits of the year for Access 2 to interpret the date as being in the 2000s. Recommendations: Problems may be avoided by consistently enforcing a long date format (4-digit years) for entry and display. An upgrade to Microsoft Access 95 (version 7.0) or Microsoft Access 97 (version 8.0) is recommended for those for whom the above solution is not sufficient. Description of how the product handles dates: Storage. Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting. Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. 2-digit shortcut handling: Microsoft Access 2.x interprets dates with an abbreviated year format in the following way. 1/1/00 through 12/31/99 are interpreted as 1/1/1900 through 12/31/1999 Common date usage errors: Using the Short Date Input Mask will limit your users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years               Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: Hungarian	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.

Product Summary
Product: Access 2.0	Version:	Category:Compliant*
Language: Italian	OS: 16-Bit Win	Release Date: 01 Apr 1994
Operational Range:	01 Jan 0100 - 31 Dec 9999
Prerequisites:	Access 2.0 software update: Two-Digit Date Patch (see below)
Product Dependencies:	Windows 3.1, or Windows NT 3.0 or greater
Clock Dependencies:	System Clock
Last Updated:	01 Oct 1999
Product Details
The compliance of Access 2.0 has changed from Not Compliant to Compliant* with the release of the Access 2.0 software update. See below for details. How the product handles dates: Storage Microsoft Access stores the Date/Time data type as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. See Knowledge Base article Q130514 for extended information. Microsoft Access relies on the Jet Database engine to store data. It uses shared VBA components to perform calculations on Date/Time data. Formatting Dates can be input in pre-defined and custom input formats, via an Input Mask. Input Masks enforce date entry in a particular format. Input Mask pre-defined formats include a Short Date format, which defaults to the Short Date format in the Regional Settings of the Control Panel when the mask is created. A custom Input Mask can be created to limit date entry to only 4-digit years. Microsoft Access does not require an Input Mask to enter dates. If an Input Mask is not used, the default behavior, dates can be entered in 2- or 4-digit formats. Dates can be displayed in pre-defined and custom formats, using the Format property and Format function. By default, dates are displayed in General Date format, which is a combination of Short Date and Short Time, as specified in the Regional Settings applet of the Control Panel. Custom formats can be created to display years as 4-digits. Recommendations to meet compliance: Obtain a software update from the following article in the Microsoft Knowledge Base: Q231408 ACC2: Access 2.0 Two-Digit Date Patch Available on MSL The Microsoft Access 2.0 Two-Digit Date Patch enhances the following functionality: 1. Access 2.0 will interpret 2-digit year dates based on a setting in the WIN.INI file. By default, Access 2.0 will interpret 2-digit year dates in the 1900-1999 range, which is the product’s behavior before the Two-Digit Date Patch is installed. If a user has the following section and settings in their WIN.INI file, Access 2.0 will use a date window based on a 100-year range, with the ending year being the value specified by the TwoDigitYearMax value. [Microsoft Access 2.0] TwoDigitYearMax=2029 The above settings in the WIN.INI file will change the date window for users on that machine to interpret two-digit year dates in the range 1930-2029. Two-digit years from 00 to 29 are interpreted as 2000 to 2029. Two-digit years from 30 to 99 are interpreted as 1930 to 1999.   2. Access 2.0 will store literal dates entered in property sheet values and in the query designer with 4-digit years. 3. Access 2.0 will interpret a date without a year as being in the current year of the system clock in years 2000 and later. 4. Access 2.0 will now display literal dates in modules with 4-digit years. 5. Access 2.0 will import text files using the 1930-2029 date window.   See Microsoft Knowledge Base Article Q75455 for more information on the Microsoft Access 2.0 Two-Digit Date Patch. Common date usage errors: Using the Short Date Input Mask will limit users' ability to enter dates outside of the 2-digit year short cut range (see the above section on 2-digit shortcuts). Use Date/Time fields in tables to store date data. Avoid using Text fields to store date data. Use a 4-digit year format to display dates. Avoid the use of the Short Date format (mm/dd/yy). Use the Long Date format, the Short Date format in conjunction with the Regional Settings in the Control Panel, or a custom format to display all digits of the year (mm/dd/yyyy). Text export, including the use of the VBA TransferText, method should always be set for export of four digit years. Testing guidelines and recommendations: In general, avoid testing in a production environment because we cannot predict side effects with other products. Interoperability testing with other Microsoft Office products can be conducted safely. The following areas should be looked at to verify dates are being properly used. The table below can be used to guide testing of Access within your organization. Functionality Areas Affected Testing Notes TransferText, Import/Export Tables, Queries, Forms, Reports, Macros, Modules Import and Export of text files is available using the menus, the Transfer Text Macro Action, and in VBA code using the TransferText method.  Date data in 2-digit and 4-digit year format can be imported and exported using an Import/Export Specification. By default, dates are exported in a 2-digit year date format. The 4-digit year format can be selected when creating an Import/Export Specification. Indexes Tables Date and time values can be indexed, and can require unique values. Format Tables, Queries, Forms, Reports, Modules Provides formatting of Date/Time data in Tables, Queries, Form, Reports, and VBA Code. Exists as a property for Table, Query, Form and Report fields. Also implemented as an intrinsic function, Format(). Formats based on Regional Settings in Control Panel: Long Date, Short Date, Long Time Access Intrinsic Formats: General Date, Medium Date, Medium Time, Short Time Custom Formats: Any combination of month, day, year, and time Input Mask Tables, Queries, Forms, Reports, Modules Limits user data entry to specific values. Values for Input Mask are derived from combinations of token characters such as (0, 9, and X), similar to custom Format properties. However, the validation and formatting of date data is done after the user has entered the data into the input masked field. Wizard defined input masks include: Short Date, Medium Date, Short Time, Medium Time, Long Time Validation Rule Tables, Queries, Forms A Validation Rule is an expression that Access uses to verify data entered by the user. The Validation Rule expression can use Date/Time data from fields and perform comparisons on calculated date values. Aggregate Queries Queries Users can group and sort queries on Date/Time fields. Aggregate queries also allow Date/Time fields to have totals calculated for the group date. The calculations allowed are: Sum, Avg, Min, Max, Count, StDev, Var, First, Last Domain Functions Queries, Forms, Reports, Modules The Domain functions perform look-ups and calculations on data and return the results. These functions are DAvg, DCount, DLookup, DFirst, DLast, DMin, DMax, DStDev, DStDevP, DSum, DVar, and DVarP. Insert Date & Time Forms, Reports Inserts a calculated field that uses the Format function on the value of Date(). Charting Forms, Reports Forms and Reports can display charts that display Date/Time data based on a record source provided by Access. Calendar Control Forms, Reports, Modules Value property allows user to get and set dates on calendar. Year is always displayed as four digits. Report Grouping Reports Reports can group and sort Date/Time data based on Each Value, Year, Qtr, Month, Week, Day, Hour, Minute. Day(), Month(), Year(), WeekDay() Queries, Forms, Reports, Modules Parses Date/Time data. Date(), Now() Queries, Forms, Reports, Modules Returns Date, and Date and Time DateAdd(), DateDiff() Queries, Forms, Reports, Modules Performs calculations on Date/Time data. LastUpdated, DateCreated properties All database objects Date/Time stamp of last update and object creation, provided by DAO. CDate() Queries, Forms, Reports, Modules Valid ranges are -657434 (1/1/100) to 2958465 (12/31/9999). Time is stored in the decimal portion of the number.   Are there other known issues in the product that are date related?       How To Articles Q162718 HOWTO: Prepare Visual Basic Applications for the Year 2000 Q109703 ACC: How to Find the Number of Days in a Month Q149095 ACC: How to Format Dates Regardless of Regional Settings Q141536 ACC: How to Convert Short Time Format to Different Formats Q132101 ACC: How to Get the Fiscal Year/Month of a Particular Date Q95907 ACC: How to Display Only the Last Two Digits of Any Year Q92816 ACC: Converting Julian Dates with Visual or Access Basic Code Q88657 ACC: Functions for Calculating and Displaying Date/Time Values Q103138 ACC: Function to Get Date of Monday Prior to Current Day Q100136 ACC: Two Functions to Calculate Age in Months and Years       Informational Articles Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data Q98802 ACC: Date/Time Data Type Provides Current Year Automatically Q142009 ACC: How Windows Regional Settings Affect Microsoft Access               Other Date Issues Q114832 ADT/ODE: Calendar Control Cannot Format Individual Dates Q96897 ACC: Operation Stops When Editing Attached SQL Tables Q125003 ACC: DateDiff() Ignores Start Date, Not End Date, with "ww" Q106290 ACC: Using Format() and Month() Returns Incorrect Month Q103996 ACC: Imported Microsoft Excel Date Fields Are Off by 4 Years Q103174 ACC: Exporting Date Fields to Text Includes Time Format Q173097 ACC: Query w/Time Criteria Returns No Records from MS SQL Server Q104973 ACC: DateDiff() Function Returns Incorrect Value

Legend of Symbols:
*	The product is compliant. User action is recommended, which may include loading a software update or assessing shared technology.
#	The product is compliant with an acceptable deviation from Microsoft's standard of compliance. An acceptable deviation does not affect the core functionality, data integrity, stability or reliability of the product.
+	The product is compliant . Software updates are pending. Future maintenance actions will be recommended shortly.
Note: Compliance ratings given for each product assume that all recommended actions have been taken.