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

learn more… | top users | synonyms

0
votes
1answer
34 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
237 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 ...
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 ...
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
96 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:...
3
votes
1answer
43 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
41 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
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
37 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 ...
0
votes
1answer
23 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 ...
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
28 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-...
1
vote
2answers
20 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")...
0
votes
2answers
52 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
47 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 ...
2
votes
0answers
38 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 ...
1
vote
1answer
119 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 ...
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 ...
0
votes
1answer
48 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: ...
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 ----------------------------------- ...
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 ...
3
votes
3answers
135 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
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, ...
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
90 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
297 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 ...
0
votes
0answers
52 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 ...
3
votes
2answers
47 views

Concatenate two dates to one column

I am pretty basic user of SharePoint 2013 and I have this problem: I have to create a calculated column with two dates in them to look like this: From 21/2/2016 to 5/3/2016 but whatever I try, the ...
3
votes
1answer
393 views

How to get the current time in a SharePoint 2013 workflow?

I have two SP2013 workflows that I built in SP Designer. They both do pretty much the same thing, but for different fields. In both of them I set a DateTime workflow variable to Today. One of them ...
1
vote
0answers
19 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 ...
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
1answer
150 views

How to remove time stamp from date field in InfoPath form?

I have a drop down in an InfoPath form that grabs data from a SharePoint list. One of the fields in the form is a date field and when it gets populated with the date from SharePoint it includes the ...
1
vote
0answers
31 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
1answer
91 views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
1
vote
3answers
164 views

How can I convert the format ctx.CurrentItem.Created

I am using SP2013 on-premise. I have applied client side rendering to convert the Item created datetime to specific format. The problem is "ctx.CurrentItem.Created" always return a string format as ...
1
vote
1answer
44 views

Hour calculation

I have list with two date fields. It is also containing time information. It is based on leave request so I need to calculate hour basis for half a day leave. If user enters 8/1/2016 08:00 AM as ...
2
votes
1answer
282 views

How to use powershell to change a datetime field to “Date Only”?

I made a sharepoint 2013 list in powershell, it has a date field, but I want the date field to be "Date Only" but I don't know how to do that in powershell code. Does anyone know? Thanks EDIT: $...
5
votes
2answers
102 views

Sharepoint 2013 built in date validation

I'm trying to use the 2013 built in date validation. I want to make sure the date entered into the GoLive Date is not more that 10 days in the past. =[GoLive Date]>[GoLive Date]-10 How can I turn ...
1
vote
1answer
51 views

How to filter on System.DateTime using FilteredDataSourcePropertyFormat?

I'm using an SPGridView that displays search results and it works perfectly. Sorting and filtering works fine as well unless for the DateTime Column. When I'm trying to filter by Date I have the ...
1
vote
0answers
45 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 ...
2
votes
2answers
39 views

Adding month to calculated value

I want to created a calculated column where I add 3 months to a date. This is what I have so far. =DATE(YEAR([Last updated]); MONTH([Last updated])+3; DAY([Last updated])); SharePoint produces and ...
3
votes
0answers
51 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 ...
0
votes
1answer
34 views

Filtered view of list based on Date compared to [Today]

I am trying to create a new view for my list that is filtered if the [Date] field is too far away. T do this, I am tring to create a calculated column, "DaysAway" with something like this: =[Date]...