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

learn more… | top users | synonyms

1
vote
0answers
3 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
31 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
26 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 : ...
1
vote
2answers
15 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 ...
0
votes
2answers
37 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
14 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
25 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
13 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
55 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
29 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
15 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
29 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
40 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
10 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
68 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
8 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
16 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
53 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
186 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
35 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
36 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 ...
2
votes
1answer
172 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
16 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
72 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 ...
0
votes
1answer
78 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
29 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
79 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
119 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
198 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
83 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
43 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
41 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
38 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
47 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
30 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: ...
0
votes
0answers
53 views

Date and Time column - shifted one day if entered by Calendar

Created Task list, then created first item in it with Due Date set for today. The item looks good. If I access it from browser it shows today date. If I access it via SSOM it also shows today 12AM ...
3
votes
3answers
245 views

Display current year on 2013 list

How do I display the current year on list date? Example picture below, only the items modified last year or before have the year displayed.
3
votes
1answer
67 views

Formula for getting Modified Date equal to Created Date instead of latest Modified Date

I'm creating a Time Out column wherein it stores the Modified Date/Time of a list. However, I just want to get only the latest Modified Date/Time that is the same Date as the Created Date. E.g. ...
0
votes
0answers
74 views

Custom Event List shows wrong DateTime for All-Day-Events

I am using a Content Query on SharePoint 2013 to list all upcomming Events for the next two weeks from all Calendars on a certain Site Collection. And with the result of this Content Query I ...
1
vote
3answers
237 views

How do I format a Date for my local region in a customised SharePoint Display Template

How do I format a date in a customised search Display Template to show the date in my Region rather than UTC. I use the following XSL in Content Query Web Parts to present the date in my timezone, ...
1
vote
0answers
66 views

How to Display Modified Time and Modified By Fields Correctly with Powershell

I have a script that outputs to CSV all items/files from all Lists and Libraries. In addition, it displays the current and previous versions of an item/file. This also displays which user modified the ...
1
vote
1answer
110 views

ISO DateTime to Local DateTime using javascript

I have a ISO DateTime string "2015-10-05T08:30:00" getting through REST request. Now I need to convert it into my local DateTime. The way I am trying var isoDateTime = new ...
1
vote
0answers
22 views

External crawl only gets dates if I map to String

We crawl a site that is external to SharePoint. We have setup a lot of settings on the site and after a Full Crawl, all the properties started to show up in the Crawled Properties list. I than ...
0
votes
1answer
181 views

Format Created Date and Modified Date Columns to Display Normal Time

I have a PowerShell script that outputs to CSV all items and files from all Lists and Libraries below: function Get-DocInventory([string]$siteUrl) { $site = New-Object Microsoft.SharePoint.SPSite ...
0
votes
1answer
106 views

Daylight saving time and UTC

Can someone confirm that using UTC date storage in lists can cause problems after summer time ends? I'm in the UK, during the summertime i was in UTC+1. So when i saved a date field using the ...
0
votes
0answers
43 views

How to set the default of a Date Filter to a calculated value?

I have a List web part that has a (hidden) date column. I've added a Date Filter web part and connected it to the list. The filter is working. Setting the default to a calculated value doesn't seem ...
1
vote
1answer
366 views

Date column with default value as calculated value that gives the next Wednesday

I have a List Column that is Date only. I would like it to default to the next Wednesday (or today if today is Wednesday). What can I put in the Calculated Value field so that it defaults to ...
0
votes
1answer
29 views

InfoPath Calculated Date

I am trying to have the Calculated Date field be the first of the month, the month before Start Date. This works when the Calculated Date month is double digit but breaks on single digit months. Any ...
2
votes
0answers
47 views

CQWP XSLT ddwrt:Today() return PST time zone instead of Local time zone

I am working on CQWP webpart in Office 365(SharePoint Online). I have to get today's date for date comparison. I have use xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" for ...