Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

Date column subtracting (1) day from entered value when grouped

Asked By: Kayla Lewis Date: Nov 25, 2007 Category: MOSS Views: 306

I have a custom list that I have created, and have also created a
column "Week Ending" in which a user enters a date. When I try to
group by this column, the group heading is (1) day behind. (I.E. User
enters a week ending date of 9/28/2007. What displays in the group
header when grouped by Week Ending date is: "Week Ending: 9/27/2007")

Anyone else ever encounter this or know what might be causing it?

I have checked the time on the servers, and both are correct, and I
have ensured that both servers are on EDST, so I can only conclude that
this is a bug within SharePoint.

Tagged:date column subtracting day from entered value when grouped

1 Answer Found

Answer #1 Answered By: Titus Sweet Answered On: Nov 25, 2007

If a week ends on 9/28/2007 that means it ends on 9/28/2007 00:00:00. If you
want to include 28 September 2007 in the week then you need to use 9/29/2007 for
the wekk ending date. Similar to an Announcement that uyou enter an expires
date. If you want an announcement to show through a specific date then you need
to pout the day after as the expires date.

Didn't find what you were looking for? Find more on Date column subtracting (1) day from entered value when grouped Or get search suggestion and latest updates.