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

learn more… | top users | synonyms

2
votes
3answers
163 views

How to use relative DateTime format like '2 days ago'/'Thursday', etc

I am updating a list and it's views (put together by another developer) and am adding a new date column. Currently, there is/was an existing date column (in this case called Orig Due Date), and I ...
1
vote
0answers
17 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 ...
0
votes
0answers
38 views

How to change date formating to yyyy-MM-dd

I have got this code: dzienStart = Convert.ToDateTime(properties.AfterProperties["DzienStart"]).ToLocalTime().AddHours(-1.0); dzienStart = Convert.ToDateTime(dzienStart.ToString("yyyy-MM-dd")); ...
1
vote
1answer
27 views

CAML query to check overlapping DateTime not working

I need to check an SPList if it contains Activities that have overlapping DateTime values. An Activity is a type which contains: Date on which the activity was done (ActivityDate) Start time of ...
0
votes
1answer
36 views

Calculate 70 plus formula

I am trying calculate a UAT 70 day view that adds 70 days to today's date which represented below by the "CalcToday" column minus the UAT START DATE field plus 70 days (mm-dd-yyyy). The formula below ...
1
vote
0answers
43 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 ...
1
vote
1answer
33 views

Time-limited access to SharePoint

An user should be given access to the SharePoint-Website. This access should be limited to a variable date or a timeframe. After this date/timeframe, the user should no more be able to access the ...
1
vote
1answer
44 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 ...
1
vote
1answer
98 views

Can I output a date in French from an XSL file?

In my XSL file, I set my date like this: <xsl:value-of select="ddwrt:FormatDate(@Date, 2057, 3)" /> This gives me an English date like 07 April 2015. Can I get this date in French?
1
vote
2answers
70 views

SP2013 javascript client object model - get server time

My client machine and server machine has time offset of 2:30 hours. So when I try to retrieve Date/Time field using JSOM, it gives time according to offset. oListItem.get_item("Modified"); So how ...
0
votes
1answer
58 views

Create a Current Date and Time Variable in SharePoint Designer 2013

Is there a way to set or create a date/time workflow variable with the current date and current time in a 2013 SPD Workflow?
2
votes
0answers
75 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
1answer
68 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
16 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
19 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
30 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
46 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
31 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
109 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
26 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
108 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
17 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
25 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
24 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
164 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
84 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
33 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
95 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
37 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
45 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
36 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
91 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
120 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
276 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
50 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
38 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
84 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
60 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
104 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
35 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
77 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
201 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
37 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
69 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
596 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
124 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
28 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
80 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 ...