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

learn more… | top users | synonyms

2
votes
1answer
41 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
14 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 ...
3
votes
0answers
37 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
37 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
23 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
48 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
75 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
40 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
58 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
64 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
32 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
35 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
31 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
43 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
25 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
36 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
155 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
42 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
44 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
125 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
35 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
71 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
18 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
73 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
55 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
38 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
108 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
26 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 ...
1
vote
0answers
40 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 ...
0
votes
0answers
45 views

Default value for Date and Time column rounds up to next hour

Have a list with column type of Date and Time call Event Date We have the default value for this Event Date field of Today's Date. When users add a new item, if it is 10:02 AM, the value for Event ...
4
votes
1answer
113 views

Calculated column increase date column by one day

I want to create acalculated column that takes a date field and sets the value to the date, increased by one day. How can this be done? For ex: If date field value: 20/10/2015 calculated result will ...
1
vote
1answer
28 views

How to capture original creation date of a document while uploading into document library?

I am uploading a document in SharePoint document library and would like to capture original creation date of the document. Can anyone let me know about this? For Eg: If a document is created on 1st ...
0
votes
2answers
95 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 ...
0
votes
1answer
65 views

Using [Today] in calculated field results in “Cannot complete this action. Please try again.” error

As you can probably guess from the title, I am trying to use the formula =[Today] in a calculated field. I then use this field to compare two date fields. These represent start and end dates. Lastly, ...
0
votes
0answers
28 views

Error 0x81020014 when setting date column in UpdateListItems

I cannot update a SP list item containing a DateAndTime type column. When the Field Name='StartDate' line is commented out, no error is returned. This let me think that my URL is actually found. When ...
0
votes
3answers
64 views

sort on month and year

In my custom list i have columns month and year. Both are string column. This is my query to get data Query = @" <Where><And><Eq><FieldRef Name='Status' /><Value ...
2
votes
2answers
378 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
19 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
127 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
112 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
41 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
168 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
57 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
110 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 ...
2
votes
1answer
116 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
517 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 ...
3
votes
4answers
1k 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
77 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
230 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
32 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. ...