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

learn more… | top users | synonyms

2
votes
2answers
6k views

Assigning Today() on a DateOnlyType field on InfoPath 2010

I made an InfoPath 2010 form using a SharePoint list template. The SharePoint list has a ReceivedDate field of DateOnlyType which I would like to set using the today() or now() on a "Set a field's" ...
1
vote
1answer
786 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
1answer
36 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
21 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. ...
1
vote
1answer
574 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 ...
2
votes
1answer
46 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 ...
9
votes
4answers
6k views

Caml to get today's birthdays

I have a list with birthday field (DateTime). How do I write caml query to retrieve only the records where birthday falls on today (i.e. only comparing day and month value of birthday column to ...
4
votes
1answer
711 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
3answers
74 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 ...
2
votes
1answer
686 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
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 ...
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?
0
votes
2answers
94 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
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 ...
2
votes
1answer
52 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
63 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
31 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
34 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
42 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
35 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
149 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.
1
vote
2answers
5k views

On Sharepoint 2013 how do you show the last modified date on a page layout

Currently have a page layout were I would like to be able to display the last modified date of an article. However I can't see how this can be done as there's no snippet in the snippet gallery were ...
1
vote
3answers
114 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, ...
3
votes
1answer
41 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
42 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
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
68 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
69 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
54 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 ...
1
vote
1answer
2k 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 + "'"; ...
0
votes
0answers
36 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
98 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 ...
2
votes
1answer
592 views

Calculating dates in sharepoint list

I have two columns in a list, one called 'start date' and one called 'renewal date' what I need is for the renewal date to default to a year after the start date, i.e. Start date = 07/09/2013 and for ...
0
votes
1answer
25 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
43 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
110 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
1answer
63 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
3answers
63 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 ...
0
votes
0answers
27 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
1answer
205 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
2answers
371 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
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 ...
0
votes
0answers
126 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
108 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 ...