Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Questions tagged [date-time]

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

3
votes
0answers
131 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
0answers
121 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 ...
2
votes
0answers
24 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
0answers
174 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
175 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
18 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
98 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
47 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
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
0answers
85 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
50 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
326 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
411 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
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
0answers
325 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
399 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
2k 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
684 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
0answers
37 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
0answers
60 views

Limit Dates available for selection and limit enteries displayed by those dates

I am creating a small timereporting list and would like to have the user select from a list of limited dates. The dates should be all the date for beginning of the week (i.e. 05/04/2015, 05/11/2015, ...
1
vote
0answers
139 views

DataFormWebPart cannot sort item with Last modified properly

In my DataFormWebPart, I have set sort by Modifed column. The column is display with follow format: <xsl:value-of select="ddwrt:FormatDate(string(@Modified), 2057, 5)"/> However, when sorting ...
1
vote
0answers
245 views

Odata Queries and Date Fields

I have a calculated field that contains the logic if(date) {Yes;} else {No;} This works fine for the column's calculation, but I either need to get the result of the calculated field or need to ...
1
vote
0answers
55 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start Time]...
1
vote
0answers
20 views

Why does the time-date for document set members differ from the document set time-date after a move

When moving a document set from one library to a Records library via a modified ootb approval SP2010 workflow, the docset has the correct CST date and time, but its document set members are 6 hours ...
1
vote
0answers
215 views

Date and time in SharePoint News Archive List

I have the following method which gets the old news items and displays in the archive page. I am displaying the old news items by month wise. User will click the Month URL and then he can see the ...
1
vote
0answers
195 views

How to make report in SharePoint 2013?

I am trying to make Report of Time registration part in SharePoint 2013. And I try to use Access View but SP 2013 doesn't have Access view or I didn't find out it. If you have any advice or suggestion ...
1
vote
0answers
63 views

Combine 2 seperate date and time columns into one

I have 2 separate columns in a list document library one is date and one is time can they be combined with a calculated column? If so how? Thanks Lewis
1
vote
0answers
561 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 ...
1
vote
0answers
87 views

Wierd format of Modified date and PublishingStart

Iam having trouble with date formats of these two fields: Modified and PublishingStartDate. They are different in format. Iam attaching how they display on my computer. I have regional settings set to ...
1
vote
0answers
274 views

Week number formula for date and time column

What calculated field formula would show me the week number for a date and time like this: 5/27/2012 6:00 AM All the formulas I found are only for dates.
1
vote
0answers
10k views

Set Due Date using a Workflow for a date 2 days after the item was created

Running into trouble using Designer. I need my workflow to set the due date for 2 days in the future but it will only let me set today's date or a specific date as the value.
1
vote
0answers
108 views

Why does Search only accept YMD date format when Search Language is en-ca (usually DMY date format)?

For some reason the server thinks that the date format for English (Canada) is YMD or yyyy/MM/DD, and the server will only correctly read queries with that format. However, the default short date ...
0
votes
0answers
21 views

Refinablestring Date Column Range Results using Search Rest API

We have a Document Library in SharePoint Online with Date Column and it was mapped to RefinableString00 Managed property. currently we are getting the search result using the below api url "/_api/...
0
votes
0answers
21 views

How to change the below explained validation from inline style to ms-form validation on migration from SP 2010 to SP 2013?

After migration from SharePoint 2010 to 2013, when we add an element and miss any mandatory field, we should get the validation errors. But in my case, when I fill the Authorized Date field and miss ...
0
votes
0answers
40 views

Prevent timezone issue and save date time as is in SharePoint using JavaScript

This maybe a common issue but my requirement is below. 1) user selects date and time using Bootstrap datetimepicker 2) If user selects 15/9/2018 12:03 PM, it should save as is Currently the timezone ...
0
votes
0answers
15 views

Making a view in a calendar based on Dates and Times in Sharepoint 2010

I have a on call calendar that I use an event based view and it uses both day and time between each day. Each item starts at 8am and rotates weekly. I created a view that only shows the items with an ...
0
votes
0answers
40 views

Create a Listview based on Date Groupings and Sorting. Date is a calculated Field

I would like to group a list by Month Year in SharePoint online. I've a calculated field that returns the date as text in the format "YYYYMM¤MMM-YY" e.g. "201806¤Jun-18" to allow sorting in the ...
0
votes
0answers
182 views

RegionalSettings.TimeZone.LocalTimeToUTC resp. UTCToLocalTime wrong?! (CSOM)

I came across a weired problem with the LocalTimeToUTC/UTCToLocalTime functions of the TimeZone class (C#, CSOM v14.0.4762.1000). The results are just completely wrong. I couldn't find any other page ...
0
votes
0answers
141 views

After change regional settings, pages with SPFx webparts gives unexpected error has occurred

After change regional settings in SharePoint 2016 On-Premise server to Bulgarian, Macedonian оr other Locale I have following error: Error from log file by corelation ID is: Message : System....
0
votes
0answers
992 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 =...
0
votes
0answers
101 views

Current time in sharepoint designer 2010

I create a workflow in SharePoint designer 2010. For each task I have to create a event in a calendar. To get a current date and time I modify list item and use "Pause for 1 min" (without pause, ...
0
votes
0answers
29 views

Comparing Calculated Date Columns

I have multiple calculated date columns and am using them to calculate some dollar amounts. These amounts are changing on every save, regardless of whether the day changes. Is this because the field ...
0
votes
0answers
245 views

How to set the default of a Date Filter to a calculated value?

I have a List web part that has a (hidden) date column. I've added a Date Filter web part and connected it to the list. The filter is working. Setting the default to a calculated value doesn't seem ...
0
votes
0answers
45 views

SP 2010 TEXT Function Subtracting 1 hour

I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as hh:mm but for some reason the output of the function is ...
0
votes
0answers
389 views

Search in SharePoint 2013 by CreatedDate is not working

Search in SharePoint 2013 by Created Date is not working in advance search web part. I have created the site column in document library "ReviewExpirationDate" add data in it . after that full crawl ...
0
votes
0answers
536 views

Removing “Due Date” from approval workflow form

Is it possible to completely remove the "Due Date" label from the approval workflow form? My customer does not use explicit due dates, and thinks it is confusing that the label for one even exists. I ...