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

learn more… | top users | synonyms

2
votes
0answers
68 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. ...
0
votes
0answers
32 views

JS Link View Overriding for date

I have a date column in my custom list. When i try to override the view of the field by using the TemplateOverride Function, my Javascript wont work on! The same problem occurs for Multiple Choice, ...
0
votes
0answers
8 views

How do I add Date and Time together for a Calendar view, maybe in workflow

We need the user to be able to select a Time slot when creating a new item, from between a cycle of 6 hours, so 12pm - 6pm, 6pm - 12am, 12am - 6am, and 6am - 12pm. They would also pick a Date. ...
0
votes
0answers
16 views

Search with other Date format doesn't work

I have a START and END site column of type date which are searchable. I've set the Locale in Regional Settings to Germany. Because of that the date is displayed in my lists in the following format: ...
1
vote
0answers
25 views

How to include time interval in CAML query? [closed]

I have CAML query in NINTEX workflow. It is fetching records from last days i,e last 24 hours. Now, i need to include time to that condition. i,e I need to fetch records from 6 AM- 12 Noon only. My ...
1
vote
1answer
28 views

Date-time field to seconds SharePoint 2013 Online

I am trying to convert the "Created" column field, or at least create a computed field, in SharePoint 2013 Online to display MM/DD/YYYY HH:MM:SS. Is this possible in the UI or is it a limitation of ...
0
votes
1answer
16 views

Address timezone issue while saving or retrieving

I have a SharePoint list having couple of DateTime properties. Currently, we are not manipulating any date-time values when saving list-item to SharePoint. It was working fine but recently we noticed ...
0
votes
1answer
65 views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
0
votes
1answer
17 views

Central Admin > Web App > General Settings > Date/Time

SharePoint 2013 with Latest SP and CU: I have setup Central Standard time for a given web application. I uploaded a document and my local central time is 11:40am but time stamp is 10:40am that means ...
0
votes
2answers
56 views

Javascript CAML Query using DateTime

I have the following CAML: <Where> <And> <Eq> <FieldRef Name='Author' LookupId='TRUE' /> <Value Type='User'>473</Value> ...
0
votes
1answer
31 views

How to set the release date of a post in SharePoint?

We wish to post something to the SharePoint website, e.g. an announcement, a calendar schedule, etc. But we do not want users to see those posts until the release date. Is there a way to set ...
1
vote
0answers
14 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
1answer
20 views

SharePoint Search not working with datetime

I have configured a search on SharePoint 2010 and i got all results as expected from each field. But when i search using date (5/19/2015), i don't get results from site. I have already make field ...
0
votes
0answers
21 views

Business Connectivity Services DateTime formatting

I have a SQL Server database with a number of columns of type Date. I have used BCS to create External Content Types in SharePoint 2013 for the tables in my database. However when a view these content ...
1
vote
1answer
84 views

Date Time format confusion in my SharePoint 2013 server

I want all my date columns in the entire server to be in 'DD/MM/YYYY' format. So I setup the Locale in the regional settings as 'United Kingdom'. I did the changes in the following locations: ...
1
vote
1answer
43 views

Check SP datetime control is empty or not

I want to check whether a Sharepoint datetime control is empty or not. How can I do this using jQuery?
0
votes
0answers
24 views

DateTime.ToLocal() in 2013 Workflow (British Summer Time problem)

I have a 2013 declarative workflow that I'm developing in Visual Studio. I grab the date from a column in a list and store it in a variable in the workflow. I have an email in which I want to display ...
0
votes
1answer
74 views

How to calculate the total days between two selected calendar dates

I've startDate = 7/16/2015 and endDate = 7/20/2015. This 2 dates are stored in a SharePoint list. If user select the exact date with the date in SharePoint list, it can calculate the total days = 2 , ...
1
vote
0answers
28 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 ...
0
votes
1answer
27 views

Calculated column to find due date

I need to create a calculated column that will read in the date from one column and compare it to today's date. The problem is the the date column is a dropdownlist with dates entered in the format of ...
0
votes
0answers
26 views

Date Comparison - Dataview Webpart in XSL

I have a site with Regional settings set for UK English and I'm using the following in xsl to compare a date field with current date value so that I can conditional formatting: ...
0
votes
2answers
60 views

Column Validation for day Monday OR Friday

I'm working with a date and time column and need a validation that returns true if the day of the week is Monday OR Friday. Users are not permitted to add an item on any other day of the week. ...
0
votes
1answer
71 views

SP.TimeZone.utcToLocalTime how to use

I'm trying to use SP.TimeZone.utcToLocalTime via REST API, but can't understand which format is right for input (with Date and Time). It works only with date ...
1
vote
1answer
177 views

SharePoint 2010 REST Date/Time format

In SharePoint 2010 REST API when I call to _vti_bin/ListData.svc/Documents(38)/Created and get JSON response the date/time is returned as /Date(1421146908000)/ (I found some information about it but ...
0
votes
0answers
45 views

How to unify date formats on web parts

I have three web parts on my SharePoint 2013 page which show an item with the latest date of modification. These web parts are based on: Announcement app (so basically list with customized layout, ...
0
votes
2answers
30 views

Problem converting the timestamp 1426593600000 to a date

I am trying to get some calendar items based on the StartTime field. I've done this: /_vti_bin/ListData.svc/MyAgenda?$filter=StartTime%20gt%20datetime%272015-03-16T19:00:00Z%27 This show me the ...
3
votes
1answer
74 views

Using NOT on REST date query

I am able to filter for items created on a specific date with the following query (using today [03-06-2015] as an example): "$filter=Created ge datetime'2015-03-06T05:00:00.000Z' and Created lt ...
0
votes
1answer
28 views

date column validation

Is it possible to validate the end date to be not greater than by 30 days over the start date? So if the Start Date is February 18, the End Date cannot be more than 30 days past February 18. Thank ...
1
vote
1answer
91 views

Filename Date Format SharePoint 2013

I am trying to change the filename date format for an InfoPath form generated item. Currently I am using this file name formula: concat("Backup", "-", today()) Which results in this filename ...
0
votes
0answers
31 views

Render SPList Date Time Control inside a Non SharePoint iFrame page

I am rendering an SP Online List inside a non SharePoint web application. I have overcome the SP security issue of This content cannot be displayed in a Frame...... by adding the following top the ...
1
vote
1answer
68 views

Content Organizer creates wrong modified date (2013)

We are using Content Organizer feature to route documents from one site collection to another. We have noticed that upon arriving to the destination documents library, each document has wrong modified ...
0
votes
1answer
121 views

CAML query datetime - publishingstartdate

I'm trying to get a CAML query working with dates - specifically PublishingStartDate and PublishingExpirationDate. When scheduling an item, there is the option to select 'immediately' and 'never' ...
0
votes
1answer
32 views

How to specify a specific range of dates

I have a List that tracks certificates. I need to limit two of the input fields and I'm not sure how. I have a formula (=[Expiration Date]>[Last updated]) in place that prohibits an Expiration ...
0
votes
0answers
14 views

How to set a default calculated date 36 hrs from “Now”, Excluding Weekdays

I can set the default to =Today+(36/24) but it calculates from 12am. I want it to calculate from the current time, so 36 hrs from Noon or after would be 2 dates ahead. Ideally, I would also like to ...
1
vote
1answer
55 views

Seconds since item created with REST. Perhaps use server current time (clock)

I'm trying to find the most correct way to determine the amount of seconds since an item was created. My first approach is to simply diff the Created property with the browser time, e.g., ...
0
votes
1answer
288 views

Updating a list item using date() function

I have a column [ScheduleTime] which is a DateTime type in my List. Using JavaScript i need to update the [ScheduleTime] column which should be Current Day whenever my script loads. But here I need to ...
0
votes
1answer
99 views

How To Get Current Date In Long Date Format in a Site Workflow

I have a requirement to get the day of the week into a workflow variable in a SharePoint Designer Site Workflow. This means I do not have a "Current Item" that the workflow runs on. How can I ...
0
votes
2answers
27 views

Changing just the year for all rows in a date column

As the title says I need to change the year for all rows in a list to 2015 from 2014 but leave the month and day the same for each. Had this been built as a calculated date column it would be much ...
1
vote
0answers
74 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 ...
0
votes
0answers
46 views

CAML query to Filter data on “DateTime” on a sharePoint 2007 list

I am trying to create a web part as a report to filter list data based on date and time I've created CAML as follows <Value IncludeTimeValue='TRUE' Type='DateTime'> Further I've ensured ...
1
vote
1answer
45 views

Workflow not behaving correctly

I have a work flow that fires off email notifications at specific dates, based on the number of days between the Expiration date and Today. It works up until a user goes to change the date of the list ...
0
votes
1answer
47 views

DATEDIF in Workflow

Is it possible to use DATEIF inside a workflow? Right now I have: =DATEDIF(TODAY(),[Expiration Date],"D") Is this possible inside a workflow if? is there a certain benefit to it? Thanks.
0
votes
1answer
34 views

How to validate on an absolute date?

I have a datetime field named "Date", and would like to only allow values within a specific range, say March 2015 - June 2016. Is there an easy way to do this? This rather hard one doesn't trigger any ...
3
votes
2answers
160 views

REST $filter when comparing 2 date columns causes error <nativehr>0x80070057</nativehr><nativestack></nativestack>

I'm using the on prem SharePoint 2013 REST API and I'm getting an error when I try to compare two date fields. $filter=ExpectedDelivery gt NeededBy The above query works perfectly using ...
0
votes
2answers
127 views

JSOM and UTC conversion

I'm using client Object Model to filter a list and display an event date. When displayed I see a UTC date format. How can this be converted to UK date format using Javascript object model? Is it ...
0
votes
0answers
67 views

How to retrieve the ISO/original value of a DateTime column in a list using CAML?

I'm using SharePoint Foundation 2013 and I want to retrieve the data in my DateTime column. Is there a way to retrieve the original/raw values or ISO values of a DateTime column using CAML query? ...
0
votes
0answers
35 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
18 views

datasheet view: colons instead of dots in time columns

I have a calendar in datasheet view on a Sharepoint 2013 site. When I enter a new calendar item and fill the "Start Time" and "End Time" , the time is not picked up correctly (from the time picker) ...
0
votes
1answer
1k views

REST API filter by month

I would like to filter a datetime field but I only want to filter MONTH var requestUri = "xxxx/getByTitle('Contact')/items?$select=CellPhone,mdate,ddate&$filter= Birthday ge '" + today + "'"; ...
0
votes
0answers
43 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 ...