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

learn more… | top users | synonyms

1
vote
2answers
122 views

Calculated Column with time element

I know I've read that dates and time don't do well in lists. Does anyone know a workaround to create a calculated column that will bump the number up in the column by 1 every 24 hours. So the column ...
1
vote
3answers
363 views

In a Page. How to add a flag that inform last time a list was modified

I have a custom page like this : These are my links (refresh once a day. Last refresh time : **XXXXX** ) link1 link2 link3 And I have a custom list. I want to add "last modified time" or ...
1
vote
1answer
752 views

How to default a date field to a particular day of the week?

When a new list item is added, I'd like a date field (Date From) to be defaulted to Monday of this week, as well as another date field (Date To) to Sunday of next week (creating a 1 week span ...
1
vote
2answers
4k 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
2answers
5k views

setting current date time in sharepoint form field (newform.aspx) sharepoint 2010

I am working on customizing the sharepoint list form (newform.aspx). So soon as the user opens the new form I want the Odate coloumn (date and time) to be filled automatically with the current date ...
1
vote
1answer
492 views

Converting date from utc to regional setting (cultural info) of the site

I have a question, basically i have a date time which is by default in UTC, how do i programmatically convert it to a correct date time in regional settings of the site collection / or user?
1
vote
1answer
98 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
1answer
104 views

Filename Date Format SharePoint 2013

I am trying to change the filename date format for an InfoPath form generated item. Currently I am using this file name formula: concat("Backup", "-", today()) Which results in this filename ...
1
vote
1answer
185 views

What is SP.dateTimeUtil.js?

I found SP.dateTimeUtil.js contains all date and calendar formats and modified one of them to customize display of dates but SP 2010 doesn't use this file anywhere. I need customized Calendar.aspx and ...
1
vote
3answers
1k 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
3k views

Date & Time column display strange value in disp form

I have created a date & time type of column in my custom list, I have selected date only as display format. I can just fill date in this field on new item form but when i see this field in display ...
1
vote
1answer
276 views

SharePoint 2010 REST Date/Time format

In SharePoint 2010 REST API when I call to _vti_bin/ListData.svc/Documents(38)/Created and get JSON response the date/time is returned as /Date(1421146908000)/ (I found some information about it but ...
1
vote
1answer
69 views

Seconds since item created with REST. Perhaps use server current time (clock)

I'm trying to find the most correct way to determine the amount of seconds since an item was created. My first approach is to simply diff the Created property with the browser time, e.g., ...
1
vote
2answers
79 views

How to trim down date to example 2014-10-10?

How can i trim down date from this Fri Oct 31 2014 01:00:00 GMT+0100 (Västeuropa, normaltid) to this 2014-10-31 on my get_fieldValues i think i can use .setDate.getDate()+ 1).toISOString().substr(0, ...
1
vote
2answers
957 views

Field Modified shows date, but no time

In a view of a document library I have the field "Modified" and this is showing only dates but no time. I would like to display the time aswell. From my understanding it is ill advised to alter this ...
1
vote
2answers
201 views

Find Interval Between Dates Problem

I have a very odd problem, one that's been baffling me for over a week now. I have a workflow designed to create a new task a set period of time in the future once a current task expires. These tasks ...
1
vote
2answers
139 views

Create SPList Metadata

I want to give a SPLists a Expiry Date so they are later deleted through a timerjob. The value is set by the user when they create a list through my functioning visual webpart. Is it possible to give ...
1
vote
1answer
2k views

Date column showing as “Date and Time” even though “Date Only” selected

In a workflow I have set up on a list, the email that is generated is showing a date with both date and time, with the time at 12:00:00 AM (using a lookup of one of the list's columns). Checking the ...
1
vote
2answers
1k views

Display and Sort on Date and Time Managed Property

I'm using a CoreResultsWebPart to display the latest articles in a short list. To display the last modified Date and Time I've created a Managed Property called LastModifiedDateTime (I'm aware of the ...
1
vote
1answer
3k views

JavaScript SP.CamlQuery() return DateTime fields with offset (in my case +11 hours)

JavaScript SP.CamlQuery() return DateTime fields with offset (in my case +11 hours). In standart Display/Edit forms and views display correct DateTime. How to get correct DateTime via SP.CamlQuery()? ...
1
vote
1answer
8k views

Add a last modified date column for each row in Sharepoint 2010 list

I have a list where I have some columns, my requirement is that I need to add a column, which will update the last modified date for each row. That is if I edit one row today, add today's date to ...
1
vote
1answer
27 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 ...
1
vote
1answer
33 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
2answers
70 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 ...
1
vote
1answer
46 views

Date-time field to seconds SharePoint 2013 Online

I am trying to convert the "Created" column field, or at least create a computed field, in SharePoint 2013 Online to display MM/DD/YYYY HH:MM:SS. Is this possible in the UI or is it a limitation of ...
1
vote
1answer
25 views

SharePoint Search not working with datetime

I have configured a search on SharePoint 2010 and i got all results as expected from each field. But when i search using date (5/19/2015), i don't get results from site. I have already make field ...
1
vote
1answer
193 views

DATEDIF statement in SharePoint not working properly

I am trying to calculate the amount of days between two dates but my formula doesn't seem to be working properly. It's as is the function is ignoring the years in the dates. My function is as follows, ...
1
vote
1answer
28 views

Formatting the date after outputting from list

I have outputted a date type from a list of mine like so while (listItemEnumerator.moveNext()) { var oListItem = listItemEnumerator.get_current(); ...
1
vote
2answers
240 views

List validation on sharepoint 2010 list

I tried to add validation on sharepoint 2010 list to validate 4 columns but, the length of this validation is greater than length of text box to write the formula. Is there any way to expand this text ...
1
vote
3answers
697 views

Calculate the difference between system columns Created on and Modified on

I'm trying to create a new column in a shp list that contains the difference in days between two other columns in that list. These two columns are the custom list columns that contain the date Created ...
1
vote
1answer
1k views

Date column value changes because of DST

A list includes a column "Date" of type Date and Time, Date and Time Format is Date Only. An item is saved via web-service and is set to value such as 2013-04-01T00:00:00Z. When this same item is ...
1
vote
1answer
1k views

sharepoint date column calculation

This is my first day using SharePoint and I was lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I am using SharePoint 2010. I ...
1
vote
2answers
2k views

CAML OffsetDays

please help if it possible that CAML OffsetDays is not working in DvWP? I use the following CAML within a DVWP: <View><Query> <Where><And> <Lt> <FieldRef ...
1
vote
2answers
298 views

SP 2010 REST $filter column

I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
1answer
1k views

Sharepoint Designer add time to date action

Is there any documentation on how SP adds time to a date? For example, if I add one month to today (say it's the 31st), does SP return the last day of the next month (the 30th)? What about leap years? ...
1
vote
3answers
6k views

How to convert date field in single line of text using Calculated columns

I have created a calculated field for a content type in my Sharepoint 2010 and I want to return a date in the TEXT format because I am returning some text with it. The condition I have put in the ...
1
vote
1answer
3k views

How to set empty value to DateTimeField WebControl?

We tried to use DateTime.MaxValue to set empty value for DateTimeField and it works quite nice on our test environment, but we get following exception on some production farms. Exception: Ticks ...
1
vote
1answer
999 views

Calendar DVWP to show only today with recurring and all day events

I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
1
vote
2answers
1k views

How to set date field to Today's Date in Wss 3.0 Custom list form programatically

How can i pre-populate newitem.aspx form with today's date. When user adds new item i want to prepopulate date field with todays date. <SharePoint:DateTimeControl ID="dtcDateofInsp" ...
1
vote
2answers
389 views

sharepoint designer - collect data from task - date and time

I'm using sharePoint designer 2010, I have creted workflow. I used the task "Collect Data From User", and I defined field as "date and time" type. the user filling the task field and I can see the ...
1
vote
2answers
156 views

Calculating event lengths that cross time changes

I have a calculated field to work out the length of an event in days, as follows: =DATEDIF([Start Time],[End Time],"d") I live in the UK and we're currently on BST; so if I create an event in GMT ...
1
vote
0answers
17 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 ...
1
vote
0answers
44 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
45 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 ...
1
vote
0answers
30 views

How to include time interval in CAML query? [closed]

I have CAML query in NINTEX workflow. It is fetching records from last days i,e last 24 hours. Now, i need to include time to that condition. i,e I need to fetch records from 6 AM- 12 Noon only. My ...
1
vote
0answers
17 views

Limit Dates available for selection and limit enteries displayed by those dates

I am creating a small timereporting list and would like to have the user select from a list of limited dates. The dates should be all the date for beginning of the week (i.e. 05/04/2015, 05/11/2015, ...
1
vote
1answer
164 views

Date Time format confusion in my SharePoint 2013 server

I want all my date columns in the entire server to be in 'DD/MM/YYYY' format. So I setup the Locale in the regional settings as 'United Kingdom'. I did the changes in the following locations: ...
1
vote
1answer
84 views

Check SP datetime control is empty or not

I want to check whether a Sharepoint datetime control is empty or not. How can I do this using jQuery?
1
vote
0answers
37 views

DataFormWebPart cannot sort item with Last modified properly

In my DataFormWebPart, I have set sort by Modifed column. The column is display with follow format: <xsl:value-of select="ddwrt:FormatDate(string(@Modified), 2057, 5)"/> However, when sorting ...
1
vote
1answer
77 views

Content Organizer creates wrong modified date (2013)

We are using Content Organizer feature to route documents from one site collection to another. We have noticed that upon arriving to the destination documents library, each document has wrong modified ...