jueves, 02 de agosto de 2012 16:43
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.
Todas las respuestas
viernes, 03 de agosto de 2012 12:45Moderador
viernes, 03 de agosto de 2012 14:08Moderador
Your best bet is to post this issue to this forum:
viernes, 03 de agosto de 2012 14:14
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).
martes, 07 de agosto de 2012 13:46
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.
- Marcado como respuesta Korb martes, 07 de agosto de 2012 13:46