Data differences using Excel Pivot Table (Sharepoint 2010)

Question

Hello, 

I have a list in Sharepoint that captures various information - one of them being a date.  No time, just a date.

I view the list in Datasheet view and export to excel and make my pivot table how I like.  The filter I choose is "date".  I am seeing multiple choices for the same date when I try and filter.  I am noticing that items entered by a user in MST are seperated from the users that enter items in CST time zone.  The Sharepoint is set to CST.

So, when I filter on date i see: 8/15/2012 and I see 8/15/2012. No difference in the date format or anything, just two of the same options.

Any idea why this is happening?  I'm guessing it has to do with the timezones since that is the only difference I can tell so far.

Thanks

michelle

---

michelle korb

Answer 1

Hi,

Thank you for your post.
I'm trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thanks ,
Entan Ming

---

Entan Ming

TechNet Community Support

Answer 2

Hi Michelle,

Your best bet is to post this issue to this forum:

http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads

Gregg

---

MSFT

Answer 3

Thanks Gregg, but I'd like to keep this open here as well and see if Entan can come up with something (as he did reply also).

---

michelle korb

Answer 4

I got the answer in excel forum:

The date picker must always implicitly choose midnight local time when the user selects the date, which the SharePoint server then translates to CST when it stores the value in its database.  If you only have users in North (or South) America, as a quick fix you could just surround the picked date with a Round() call, which should trim out the hh:mm:ss information properly.

---

michelle korb