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

learn more… | top users | synonyms

0
votes
1answer
110 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 ...
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
1answer
709 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?
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
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 ...
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")); ...
3
votes
1answer
597 views

SharePoint Bug? Conflict Error when saving a Page with a “Required” DateTime field in the page layout

I've just recently encountered a weird error / bug in SharePoint. Here is the scenario: I have a custom column "Test Date" that is of DateTime field type. The field is configured as required. It is ...
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
1k views

How to set the date on the DateTimeControl on SharePoint 2010?

Want to enforce the Users to select only Friday. As it does not seem to possible, would like to set programmatically when user selects the date. It works fine behind the scenes however on the browser ...
1
vote
0answers
44 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 ...
2
votes
1answer
37 views

List formula date conditional not working

I have a list that takes an Open Date and adds 90 days to set a due date: =[Open Date]+90 However, many of the Open Dates are years old. I've been asked to change it so that dates created before ...
3
votes
4answers
8k 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 ...
1
vote
1answer
46 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
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
2answers
389 views

sharepoint designer - collect data from task - date and time

I'm using sharePoint designer 2010, I have creted workflow. I used the task "Collect Data From User", and I defined field as "date and time" type. the user filling the task field and I can see the ...
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?
0
votes
1answer
70 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, ...
1
vote
2answers
71 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
59 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
2answers
7k views

Check for empty date in SPD Workflow

Question How can I check for an empty date condition in a SharePoint Designer Workflow? Background I have a list called "Project" with multiple date fields. I have a calendar called "Project ...
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
47 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
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
109 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
166 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
86 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?
1
vote
2answers
79 views

How to trim down date to example 2014-10-10?

How can i trim down date from this Fri Oct 31 2014 01:00:00 GMT+0100 (Västeuropa, normaltid) to this 2014-10-31 on my get_fieldValues i think i can use .setDate.getDate()+ 1).toISOString().substr(0, ...
0
votes
0answers
36 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 ...
6
votes
3answers
9k views

REST API filter by start and end dates using 'today'

I'm new to filtering dates with REST in SP but am trying to do something like below but am not sure how to get today's date in as a variable into the request. I don't think I'm too far off so any help ...
0
votes
1answer
98 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 ...
3
votes
1answer
85 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 ...
3
votes
2answers
205 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 ...
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
0answers
37 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
93 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. ...
1
vote
1answer
279 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
1answer
122 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 ...
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 ...
0
votes
2answers
46 views

Incorrrect Date Format on Blog Posts

I have a SharePoint 2013 On-Premises farm, and the regional settings are set to 'Ireland' (for which date format is dd/mm/yyyy). If I create a Blog Post in my personal site on 6th Jan 2014, it shows ...