All Questions
16 questions
0
votes
1
answer
35
views
REST api returns incorrect date for one DateTime column but the correct date for another DateTime column in the same list
We have a list with a few DateTime(Date only is set) columns which are created through Powershell and there's no difference between them except the name. On a custom search page REST api is used to ...
- 3
1
vote
0
answers
283
views
Date time column value is off by one hour
SharePoint showing one hour less in UI in one site collection and correct value in another site collection and both site collections/sites having same regional settings and programmatically it is ...
- 517
1
vote
1
answer
12k
views
SharePoint Date wrong in Power Bi
I have a list in sharepoint where in create items with date and time amongst other data.
Eg. I have one where I entered the date 14-06-2019 05:00:00
Now when I pull this into Power Bi the date is 14-...
- 157
0
votes
1
answer
1k
views
SharePoint 365 List DateTime column needing no Time Zone affiliation
I have a SharePoint 365 custom list for my configuration team to receive requests from our internal business customers. There are date time fields for start date and end date of the configuration ...
- 1
0
votes
0
answers
2k
views
REST API Date Time Zone issue
I am fetching records from the list using rest api by filtering date field in it. however i am getting a different result from different time zone. any kind of help will be appreciable.
var today =...
- 574
2
votes
2
answers
4k
views
How do I add hours to Now() after converting it to a text value?
I have a calculated field that shows the text value of the current hour, so I'm using:
=TEXT(Now(), "hh")
Unfortunately, it's showing this value in Pacific time, so I'd like to add 3 hours to ...
- 427
5
votes
1
answer
2k
views
SharePoint JSOM datetime values in different timezones
I am working on a solution (on SharePoint Online) which is used by users in different timezones. SharePoint site is configured for "W. Europe Standard Time".
Following occurs:
A user from US creates ...
- 708
1
vote
1
answer
2k
views
How to Display Correct Times for Users Regardless of Their Time Zones
I have an InfoPath form on my List. One of the controls on this form is called LoggingTest of type "Multiple lines of text". Below are the settings for this column on my control:
The purpose of the ...
- 935
5
votes
4
answers
5k
views
SharePoint DateTime issue when date is saved using CSOM
The timezone set in SharePoint Online is EST and when it is being saved to SharePoint using CSOM/ECMA script from location with UTC +5:30 timezone the date is reduced. Everytime we edit the time is ...
- 1,244
1
vote
1
answer
2k
views
Daylight saving time and UTC
Can someone confirm that by using UTC date storage in lists it can cause problems after summer time ends?
I'm in the UK and during the summertime I was in UTC+1.
So when i saved a date field using ...
- 23
3
votes
6
answers
167
views
What functionality and API may be affected by DST and TZ changes? What to test?
As the 2014 RTZ datetime changes weren't implemented smoothly by SharePoint, let's brainstorm on what has and could go wrong with another change like that.
So the question is: what test cases to ...
1
vote
0
answers
741
views
SOAP returns DateTime with timezone offset added to minutes
I am using the Ruby gem 'viewpoint/spws' (from a RHEL 6 server) to insert items into a Sharepoint list via SOAP.
It seems that the DateTime fields being passed are being incorrectly interpreted by ...
- 11
10
votes
4
answers
13k
views
Why is central admin time different from server time?
I have seen this question asked before (not here) but have never seen anyone with a genuine answer, usually people provide lots of info surrounding how Sharepoint has a different timezome for each Web,...
- 532
3
votes
1
answer
1k
views
Making DateTime fields ignore user timezones
We have a number of forms using a standard DFWP to serve up some simple forms. A few of these forms have datetime fields only showing the date portion. We're experiencing some issues where user A in ...
- 412
3
votes
2
answers
6k
views
Incorrect Modified Dates on SharePoint Online for clients in other timezones
I've run into a strange problem with SharePoint Online.
When updating or creating entries in a list using the Client Object Model, the modified date on the affected list item seems to be stored with ...
- 462
4
votes
4
answers
30k
views
DateTimeField and timezone conversion problem
It seems that the datetime value which is entered into a DateTimeField is always stored as UTC no matter what timezone is configured for the current user.
Only the output on the page is displayed in ...
user2764