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

learn more… | top users | synonyms

0
votes
0answers
23 views

How to calculate duration based on 4 dates?

On Sharepoint 2013 teamsite I have a report taking which is updated by the workflow to calculate each task and overall duration. Workflow adds task start and end dates, durations are calculated per ...
0
votes
1answer
37 views

How to validate Date type column value in SharePoint list?

I have date column in SharePoint list, which is basically for a license file application. So I want that the user cannot select date unless and until he is 18+ years. What formula do I need to apply ...
3
votes
2answers
240 views

Is there a way to make a workflow run every Monday?

Context: I have a list that we use as a sort of newsfeed. I have a workflow which, when an item is created on the newsfeed, copies the contents into a new list item on a secondary list. What I am ...
5
votes
1answer
790 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 ...
2
votes
1answer
779 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 ...
1
vote
0answers
28 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 ...
0
votes
2answers
38 views

Calculated field - If date = date then return another date, otherwise date

I have two fields, StartDate and NewDate. The NewDate field, I want to calculate based on StartDate and return a date. If the Start date is greater than or equal to 3/31/2016, then enter 4/26/2017 in ...
1
vote
1answer
871 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?
0
votes
2answers
47 views

Date time issue in Sharepoint Online

I am inserting the date to SharePoint lists date time column. The issue is that it is not storing the actual selected date. I tried it with this date "2016-06-08" and with this format (yy-mm-dd): ...
1
vote
1answer
35 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
4answers
101 views

workflow 2010 will show a Date equal to 01/01/0001 inside the email, if the Date is empty

I am working on SharePoint server 2013, and i create a new Workflow 2010 inside Sharepoint designer 2013. now inside the Workflow i set an email which contain the following value:- [%Current Item:...
1
vote
1answer
854 views

Showing 1 Minute increments in time field with Sharepoint 2013 list

My company requires our list drop downs to contain time in 1 minute increments. Is there an OOB option I can update to change this? If not, are there any options without installing a third party ...
3
votes
1answer
44 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 ...
0
votes
3answers
43 views

Showing Due days in a red colomn based upon the real date of this day and a due column date

I'm trying to figure out, how i could show a list with having real overdue date's in days based upon the current day. (maybe a client side rendering?). The problem is calculated column can not make ...
0
votes
1answer
41 views

REST API datetime range not working as expected

Background: In Sharepoint Online, I'm using the Sharepoint REST API for query a few records based on its creation date (column Created). I'm using the following variations of the REST query for get ...
2
votes
3answers
11k 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
1answer
2k 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 ...
2
votes
5answers
9k views

CAML Query Filtering with OffsetDays

I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this: If a date is not specified on the Query String, then show me items created in the last 30 days If a date is ...
0
votes
1answer
20 views

Time Displaying Incorrectly on InfoPath Form and Not Displaying Current User

I have 2 controls below. The top Text box is labeled CommentsTemp while the bottom TextBox is called Comments. How it works is, when a user enters anything in CommentsTemp, that it would be stored in ...
0
votes
1answer
25 views

Week/month calculation based on create date

I am building a SharePoint designer worklfow (2010 mode). I want to be able to determine/calculate the week and month when a workflow is created and use this in the workflow itself. How can this be ...
2
votes
2answers
36 views

How to set Date Time Column

I have a column in my List that is of type Date Time. By default I want it to display the Date as Created + 14 days. I tried the below in the column settings: HOWEVER, when I click OK I get the ...
1
vote
2answers
4k views

How to display date in Page Layout in specific format

I am using the following code to display date in a publishing page layout. <SharePointWebControls:FieldValue runat="server" FieldName="Created" id="CreatedOn"/> This displays both date &...
0
votes
1answer
34 views

How Do I Input Todays Date Into a List?

looking to add todays date into sharepoint list so that I can run multiple expiry timelines off other cells. Have looked online and tried the work arounds but can't able to get any working code. I ...
1
vote
1answer
13 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 ...
0
votes
1answer
53 views

Time Difference in SP Calculated Column excluding weekends

I have two dates (Initial Date & End Date) both date and time format in a SP List. I need to calculate the amount of days between both of them excluding weekends. I already have the formula in a ...
0
votes
1answer
30 views

Trying to make a difference between two dates, with days, hours and minutes

I try to make a difference between two dates, but displaying the days and hours. So I found a good idea on this website : https://sharepointonline.wordpress.com/2012/03/02/date-time-duration-using-...
0
votes
2answers
54 views

Setting End Date to same as start date

I have a list that I created to track start/end times for activities. I'd like to set the form so that when the user enters the start date it populates the end with the same date so that users ONLY ...
0
votes
1answer
49 views

Validation Error When Submitting Custom Infopath Form on Sharepoint List

I recently created a new list for our employees to create new Goals using sharepoint. I created a content type called “annual performance goals” and created a custom new entry form using infopath to ...
1
vote
2answers
21 views

Calculated field for difference between two times

I have a list with a "Start" field and "End" field. I'm using a calculated field to determine the difference in hours and minutes between the two. Start - 9:00 am End - 10:30 am =TEXT(End-Start,"h:mm")...
2
votes
4answers
2k views

How to show two dates in one calculated column

I'm using Sharepoint Foundation 2010. I have two columns, start date and ending date. I want to make calculated column which shows both of them in the same column. Everything is okay till I add both ...
1
vote
1answer
121 views

CAML query format filter in DateTime column

I need to get the list item created on a particular date. The below caml query doesn't seem to work. It always retuns 0 query.ViewXml = @"<View><Query><Where><Eq><FieldRef ...
2
votes
0answers
39 views

Display datepicker on top of the forms's modal dialog

I have a custom item edit form and I have a couple of DateTime properties that has to be filled at the bottom of the form (using datepicker): So when I click the mini calendar icon to choose the ...
0
votes
0answers
14 views

Word Template's DateTime Always One Day Off?

I have a library with custom content type with .docx template. I have a 'StartDate' and 'EndDate' fields in the content type which are mapped to quick parts in .docx template. When I change the ...
0
votes
3answers
44 views

How to restrict date(Created) field to display only date and time?

How to restrict the date field(Created) to show only date and time instead of Fri Apr 15 2016 16:06:04 GMT+0530 (India Standard Time)? I do not want to show GMT and so on. The below is my code. ...
0
votes
0answers
19 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 ...
1
vote
2answers
3k 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 + "'"; ...
5
votes
3answers
2k views

DateTime list column with 1 minute increments

How can I change the time portion of a date time column to have 1 minute increments? When you create a coulmn by default it shows 5 minute increments, but I need to be able to use 1 minute increments. ...
0
votes
1answer
49 views

KQL - How to Create Query That Filters by Dates Within the Past Week (7 Days)

So I'm trying to create a query using KQL where one of the parameters brings back items that fall under a certain date range - only items that got modified within the past 7 days. Here it is below: ...
3
votes
3answers
136 views

SharePoint DateTime issue when date is saved using CSOM

The timezone set in SharePoint Online is EST and when it is being saved to SharePoint using CSOM/ECMA script from location with UTC +5:30 timezone the date is reduced. Everytime we edit the time is ...
0
votes
2answers
52 views

Convert Choice field value into Date format using Calculated column

I have a choice column in which choices are name of months. I want a calculated column which returns me the date format data. Choice Column | Calculated Column ----------------------------------- ...
4
votes
4answers
3k views

Get difference in Minutes for DateTime format column

I have a formula for calculated column which gets the date difference in hh:mm format. =TEXT([COLUMN2]-[COLUMN1],"h:mm") But I want to get the difference in just minutes. I created very complex ...
0
votes
0answers
12 views

Completion Date to Populate with Submitted Date + 14 days

I have a List that has an InfoPath Form and WF attached. Then scenario: When the user clicks New Item in the List, a Form appears in Submitter View. The user will then enter some information and ...
0
votes
0answers
10 views

Why is my record, within a document set, displaying a modified time of an hour ahead of reality?

Picture the scene: I've created a document set with documents inside. I've sent my document set to the records centre. The content organizer rules are doing their thing, and after the timer job runs, ...
0
votes
2answers
157 views

How to remove the seconds part from a date and time property

We have a standard Calendar app in SP2013 with some events that we roll up on a homepage using a content search web part (the Two Lines display template). We show two properties: the title and the ...
10
votes
4answers
21k 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 ...
1
vote
0answers
18 views

Help with auto calculated field for dates from another column [closed]

I am trying to make a column with expire dates from a date entered in another column. For example I have a column with a date entered for training. I then want another column named expire date that ...
0
votes
1answer
94 views

Process DateTime field value in SharePoint List Edit form

I am working on a Item Update event receiver in a SharePoint document library. One of the fields in this library is a Date and Time (Date only format) field. When a user selects a date and clicks on ...
2
votes
3answers
303 views

Set default value of Article Start Date to [Today] with CSOM

I'm struggeling with setting the default value of ArticleStartDate date-time column using PowerShell and CSOM. Bakground: I have a content type, used by a page layout, inheriting from Article Page ...
4
votes
1answer
79 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'...
0
votes
0answers
53 views

Negative DateDif Result

I'm trying to calculate the difference between 2 dates, (Starting Date) and Today. If the result is negative (IE: Starting Date is in the future) it means we still have that number of days before we ...