Microsoft KB Archive/823509

= List items in a column that stores data and time information are grouped incorrectly in a view =

Article ID: 823509

Article Last Modified on 5/31/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services
 * Microsoft Windows SharePoint Services 3.0

-





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:  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.  Create a new view and group the list items by the new column.</li></ol>

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.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_section">

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

http://office.microsoft.com/en-us/sharepointserver/FX101494611033.aspx

Additional query words: WSSv3 WSSv2

Keywords: kbpending kbbug KB823509

-

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

© Microsoft Corporation. All rights reserved.