List items in a column that stores data and time information are grouped incorrectly in a view (823509)


The information in this article applies to:

  • Microsoft Windows SharePoint Services

SYMPTOMS

When you create a custom view of a list on your Microsoft Windows SharePoint Services Web site, and then you group the view by a column that stores date and time information, you may find that some of the list items are incorrectly grouped in the view.

CAUSE

This issue may occur if all the following conditions are true:
  • You create a list that contains a column that stores date and time information by using Date & Time format.
  • List items in the column contain time values that are either one hour before midnight (11:00 pm) or one hour after midnight (1:00 am).
  • Either the current date and time do not use daylight-saving time and the list items contain date values that use that use daylight-saving time, or the current date and time use daylight-saving time and the list items contain date values that use dates that do not use daylight-saving time.
  • You create a custom view of the list that groups by the column.
In this situation, list items that contain time values that are either one hour before midnight (11:00 pm) or one hour after midnight (1:00 am) are incorrectly grouped in the view. For example, a list item with a date and time value of 07/08/2003 12:00 AM is included in the same group as a list item with a date and time value of 07/07/2003 11:00 PM.

WORKAROUND

To work around this problem, create a new calculated column that will return a date value. To do this, follow these steps:
  1. Create a new calculated column:
    • Enter the following information for the formula:

      =TRUNC([xxxxx])

      In this formula, xxxxx is the original Date and Time column name.
    • Select Date and Time for the data type that is returned from the formula.
    • Select Date Only for the format.
  2. Create a new view and group the list items by the new column.
When you use this formula, although the data type that is returned for items in the column uses Date and Time format, the formula truncates the data type so that items in the column use Date Only format.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about Windows SharePoint Services, visit the following Microsoft Web site:

http://www.microsoft.com/sharepoint/server/default.asp

Modification Type:MinorLast Reviewed:1/9/2006
Keywords:kbpending kbBug KB823509 kbAudITPRO kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.