Questions tagged [date-time]

Represents an instant in time, typically expressed as a date and time of day.

124 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
1answer
1k 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 ...
5
votes
1answer
2k views

Should SharePoint Alerts automatically adjust for Daylight Savings Time changes?

We have a SP2010 farm that is up to the October CU. After the time change, some users report that alerts that were sending out at 10am are now being sent at 9am. I've googled a fair amount and found ...
5
votes
1answer
582 views

Is there a way to change the Date format inside SharePoint sites to be shown as DD MMM YY (i.e. 25 March 2017)

I am working on a sharepoint farm on-premises 2013. currently we set the following for the regional settings:- Where all the date fields are being shown in this format dd/mm/yyyy for example ...
4
votes
1answer
103 views

How to modify DropDown Menu of a SPGridView?

I'm using an SPGridView to display search results (SP2010) and I would like to modify the way datetime column is displayed through the column menu. Schema are more meaningful than long speeches so I'...
3
votes
1answer
672 views

Need help comparing two dates with times

I'm trying to compare two dates with time. I'm able to compare just the date, but when I add the time element it doesn't work. I'm not sure what the correct format should be. <xsl:if test="ddwrt:...
3
votes
0answers
140 views

SharePoint Calendar takes next day at 23 hours

I have a SharePoint custom Form where I have SharePoint Default date column and three custom controls for Hours minute and Second. So by default on page load,the date in SharePoint Date Field is taken ...
3
votes
1answer
114 views

Sharepoint Jsom return wrong time

I have custom column, interview date, in custom list and I am storing date and time in column. When I fetch interview date data then it will return wrong time. If I store value in field 26 May 2016 ...
3
votes
1answer
1k views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
3
votes
0answers
124 views

Filter content search by date and time of creation

I'm using a content search web part to show news on my site. I want to show the items following a publishing date and time. I know there's the parameter StartDate <= {Today}. How can I make it ...
3
votes
6answers
149 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 ...
3
votes
1answer
457 views

Range of minutes

I have a date field and time, and want to take this 5 minute interval in the select minutes, I want to be in sequence, example: 00,01,02,03,04,05,...55,56,57,58,59. How can this be done?
3
votes
3answers
1k views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
2
votes
1answer
71 views

Range of Dates that start in 2017 and end in 2018

I am trying to use Flows to get a range of Dates as Integers that start in 2017 and end in 2018 I get my Data from the Get Events (V2) Connector and getting the Start Time and End Time to get the ...
2
votes
1answer
57 views

Can we convert Sharepoint date/time to XSD date/time

I have requirement to convert SharePoint date and time to xsd date and time. can we do this in SharePoint. Any insights would be great.
2
votes
0answers
25 views

Can we compose REST query which first apply some function on item then compare?

I have a date which is in Indian time zone, my SharePoint Online site is in different time zone. Now I have a rest query which filters the record. SiteUrl/_api/web/lists/getbytitle('ListName')/items?$...
2
votes
2answers
211 views

Unable to get event item time in SharePoint online calender list

I'm writing simple JavaScript. In that script I'm getting Event item Start date field value and End date field value from Custom calendar list. but the code retrieve different time Example: here is ...
2
votes
1answer
539 views

SP2010: Compare the value of a date column with today's date

I've a column D in a list of type Date and Time which takes only date values (not time). I want to write a javascript function to check if the value in D is less than today's date (only date, not time)...
2
votes
1answer
1k views

Change Date Format in SharePoint 2016

I want to change the format of date from MM-DD-YYYY to DD-MM-YYYY in list, Gantt charts etc. I have tried one option so far but it doesn't work properly which is explain below: First option: I have ...
2
votes
1answer
299 views

Format SharePointWebControls:DateTimeField

I am using this to return the date/time entered by a user in a page layout. I want to only show the date. I need to keep the time part as this is used in a query on another page. I have seen ...
2
votes
2answers
125 views

Setting a Workflow variable as a long date

I have seen all the suggestions for extracting the day of the week from a long date in a SP workflow. I would love to be able to set my date/time variable to a long date but the system will not let ...
2
votes
0answers
190 views

Date issues with search

In SP 2013 on prem, I am using content search web part to show customized article pages. The articles are shown in the display template if the article start date is greater than or equal to today. ...
2
votes
0answers
185 views

CQWP XSLT ddwrt:Today() return PST time zone instead of Local time zone

I am working on CQWP webpart in Office 365(SharePoint Online). I have to get today's date for date comparison. I have use xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" for ...
2
votes
0answers
116 views

The upcoming leap second and SharePoint

Is there any known issues when a leap second occurs? Leap years seems to be fine but i have yet to find any information related to leap seconds and how it could possibly have any impact on SharePoint. ...
2
votes
0answers
55 views

Different Times between View and DisplayForm in Calendar

The setup: I am using a default Calendar list in SharePoint 2010 Enterprise. The calendar is being used to track meetings in for a specific meeting room. The calendar has content approval required ...
1
vote
0answers
30 views

Odata query returns 401

I'm working with the SharePoint 2016 OnPremis OData Rest Api. The filter parameter is defined followings: $filter=Art/Value eq 'aString' and year(Received) eq 2019 Art is a choice value and Received ...
1
vote
0answers
19 views

How make publish by date MVC , sharepiont

I am working in site that publish the content by date so, every Thursday I will compare the date that the content approved to this Thursday date if its the same date (dependent on admin diction to ...
1
vote
0answers
108 views

How to validate non-clashing time ranges on items submitted through PowerApps?

I have a SharePoint list with a start time and an end time, which will be entered through a PowerApps app. One of the core rules is that those time ranges should not clash, similar to a meeting room ...
1
vote
0answers
48 views

Checkbox with User Stamp when changed

I am still a beginner in SharePoint and am looking for some guidance (I can do this in Excel, but can't figure out how to do it in SharePoint). FYI - I am stuck using SharePoint online (not ...
1
vote
3answers
1k views

How to set Date column with default value as calculated value?

One date time column: Target date Requirement: Need to set default 'Target date',5 Days ahead of item creation date. I have tried this:= but it is not working =[Target date] = [Created] + 5 Kindly ...
1
vote
1answer
66 views

SharePoint Online XML Field DateTime default on minute and NOT nearest half an hour

I have a Field (Site Column) element which is type DateTime <Field DisplayName="Created" Name="Created" StaticName="Created" Type="DateTime" ID="{28C9A5E9-513C-415A-8C41-E7A3D767EABD}" Group="...
1
vote
0answers
25 views

How to include a site column for year that can be populated using the standard calendar

I am working on an on-premises SharePoint 2013 farm. We need to have a site column which represents the "Date Published" for books and papers where we need to store a value representing the year. Is ...
1
vote
1answer
40 views

Collect Data from a User - Date and Time (without seconds)

I am creating a workflow in Sharepoint Designer 2010. In one of "collect task" I have a field "Meeting date": Information type: Date and Time Display format: Date and Time My problem is that in ...
1
vote
1answer
1k views

SharePoint Conditional Formatting Date Column

I've been trying to create a Conditional Color column for dates that are expired. The expired dates should be red and the dates that are not should be clear. I tried to use the code from http://www....
1
vote
0answers
86 views

How can I create a DateTime for a specific time with the correct UTC offset in an SP2013 workflow in VS?

I'm trying to pause a workflow until 8 AM on a specific day. I am on the East Coast of the US: UTC -5. I can create a DateTime object with a time of 8 AM like this: new DateTime(DateTime.UtcNow....
1
vote
0answers
53 views

Datetime querystring format when paging the sorted list-view

When I sort a column (ExpiryDate) in the list view and then click next page button, SharePoint generates URL like this: http://www.example.com/Lists/WatchList/AllItems.aspx#InplviewHash0691b043-5378-...
1
vote
0answers
339 views

SPUtility.ParseDate - format of the input date string

In the SPUtility.ParseDate function, the 2nd parameter is the date in string format. Is there any specific format required for this? Will it work with any format? The MSDN documentation for this API ...
1
vote
0answers
441 views

Document Library Date/Time gives “Invalid datetime value” error after changing site regional settings

Using Sharepoint Online, I've created a new column on a document library "Expiry Date". This worked fine until I changed the sites regional settings from English (United States) to English (United ...
1
vote
1answer
973 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 ...
1
vote
1answer
69 views

Elapsed time driven Automated Reminder workflow

Am trying to create a workflow (SP 2013) that checks today's date, checks the date an item was created, and if it is a week old, sends an e-mail to to creator saying "we are still working on your ...
1
vote
0answers
53 views

Validating multiple columns - one date, one yes/no

I'm having trouble figuring out how to make sure that if "yes" in the yes/no option is chosen, that a date must be entered in the "when" column and vice versa. In summary, did you buy a car? if so ...
1
vote
1answer
217 views

How to filter on System.DateTime using FilteredDataSourcePropertyFormat?

I'm using an SPGridView that displays search results and it works perfectly. Sorting and filtering works fine as well unless for the DateTime Column. When I'm trying to filter by Date I have the ...
1
vote
0answers
336 views

Custom XSL – formatting the date column in ItemStyle.xsl

I have a Content Query Web Part in which I am displaying the data from a Blog sub-site. The Item Style being used is "Title and description". Title displays the title of the document. For the ...
1
vote
0answers
413 views

Date and Time column - shifted one day if entered by Calendar

Created Task list, then created first item in it with Due Date set for today. The item looks good. If I access it from browser it shows today date. If I access it via SSOM it also shows today 12AM ...
1
vote
0answers
3k views

How to Display Modified Time and Modified By Fields Correctly with Powershell

I have a script that outputs to CSV all items/files from all Lists and Libraries. In addition, it displays the current and previous versions of an item/file. This also displays which user modified the ...
1
vote
0answers
74 views

External crawl only gets dates if I map to String

We crawl a site that is external to SharePoint. We have setup a lot of settings on the site and after a Full Crawl, all the properties started to show up in the Crawled Properties list. I than ...
1
vote
0answers
713 views

Default value for Date and Time column rounds up to next hour

Have a list with column type of Date and Time call Event Date We have the default value for this Event Date field of Today's Date. When users add a new item, if it is 10:02 AM, the value for Event ...
1
vote
1answer
352 views

How to capture original creation date of a document while uploading into document library?

I am uploading a document in SharePoint document library and would like to capture original creation date of the document. Can anyone let me know about this? For Eg: If a document is created on 1st ...
1
vote
0answers
39 views

DateTime field display diffrent values when editing and when viewing

We have an Office 365 2013 Business Premium subscription and are using Sharepoint online as our Intranet solution. Our problem seems related to DateTimeField and timezone conversion problem The ...
1
vote
0answers
2k views

Workflow - How to convert string to number to date?

I have a string strExpDate and I get the value "130836384000000000" from ldap query. The active directory field is accountExpires. I need to convert this to date/time. The result should be 8/9/2015 7:...
1
vote
1answer
980 views

Validating a set of dates in Microsoft Sharepoint

I am trying to validate dates in a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub. I, then, want that [Date of Request]...