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

learn more… | top users | synonyms

0
votes
1answer
9 views

Wrong format by ddwrt:Today()

I made a display form for my list and I had to insert the current date into text. I found this code: <xsl:value-of select="ddwrt:Today()"/> and it's working, but in Designer I see correct ...
0
votes
1answer
22 views

Programmatically (C#) set date field to blank in 2010

I have tried setting my date field to an empty string ("") and setting it to "01/01/0001". Both returned the error "String is not formatted as date time". I have several thousand items across a few ...
0
votes
0answers
12 views

Error message with date picker/format

I have a problem with the date picker for a custom created content type. The content type I have created has parent of document set. There are a host of site columns I’ve created which have been ...
1
vote
1answer
23 views

List formula date conditional not working

I have a list that takes an Open Date and adds 90 days to set a due date: =[Open Date]+90 However, many of the Open Dates are years old. I've been asked to change it so that dates created before May ...
1
vote
1answer
25 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
1answer
28 views

Timezone question for list items?

I have a sharepoint which is accessed and modified by different people around the world. So when ever a list item is created in the sharepoint the list item modified date should contain that locations ...
4
votes
3answers
253 views

REST API filter by start and end dates

I'm new to filtering dates with REST in SP but am trying to do something like below but am not sure how to get today's date in as a variable into the request. I don't think I'm too far off so any help ...
0
votes
2answers
42 views

Validate Sharepoint date time control

I have two fields; one is normal text box used to generate system current date and the another field is <sharepoint :datetime control > I need to validate this two: the date selected in ...
0
votes
0answers
14 views

Incorrrect Date Format on Blog Posts

I have a SharePoint 2013 On-Premises farm, and the regional settings are set to 'Ireland' (for which date format is dd/mm/yyyy). If I create a Blog Post in my personal site on 6th Jan 2014, it shows ...
1
vote
3answers
102 views

SP2013 Last modified date wrong in search results - day and month are inverted

We have a problem with the search results "Last modified Date". So if i take a look at the document and look at the last modified document i see "06/10/2014". This is correct cause the ...
0
votes
2answers
49 views

Insert record with Date into list via JSOM, problem with UK Format

I have found that when inserting a record which contains a Date using JSOM the update(); will not work if you specify the format of the date to be UK date (28/05/2014). The code does not error, it ...
0
votes
1answer
144 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 ...
0
votes
0answers
26 views

Use timestamp (hours, minutes and seconds) in Performance Point Chart

I am using PerformancePoint Services 2012 with SSAS 2012. I have a measure named [Duration in Seconds]. I created another Calculated Member named [Duration in HMS] which converts [Duration in Seconds] ...
1
vote
3answers
135 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 ...
0
votes
1answer
102 views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
0
votes
1answer
19 views

Update a date field when Title field is changed from blank in SharePoint 2010

I have a list where items are created with control numbers at project kickoff. I need to have a date field update when the column "Title" is first changed from blank to text. This field should never ...
0
votes
0answers
35 views

Time Zone calculations

On SharePoint 2010, so I am limited to XSLT 1.0. I have a list that contains locations (@Title) and time offsets in relation to GMT (@TimeOffset) and want to calculate the current date and time for ...
0
votes
0answers
37 views

date in utc not in current for keywordquery

I use Keywordquery for making a custom search result. I've some managed property and one is date format. The issue is if i look the value for date in powershell I get 2013-04-03 23:05 but when I ...
0
votes
1answer
176 views

Content Search Web Part - Sort by Scheduled publishing date

I am a developer working to transfer a wordpress site to SharePoint 2013 using cross site publishing. This means an authoring site to create pages, and a publishing site to display them. On the ...
3
votes
1answer
68 views

Range of minutes

I have a date field and time, and want to take this 5 minute interval in the select minutes, I want to be in sequence, example: 00,01,02,03,04,05,...55,56,57,58,59. How can this be done?
0
votes
1answer
46 views

sp2013: set datetime column + 3 year in some condition, how?

I have a sharepoint 2013 site. I have a custom documentlibrary with 4 custom contenttypes. When I upload a document I can select a contenttype and see 1 datetime column. I would like to set the ...
0
votes
1answer
29 views

Hiding Hour / Minute Options for Time/Date Column in forms

SharePoint 2007 environment. If I wanted to limited the options in the hour column (10 - 17 hrs) and time intervals in the mins slot (30 mins only), what's the best way to achieve this. I'm thinking ...
1
vote
2answers
66 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 ...
0
votes
0answers
15 views

Dates Transposed in Custom List Group Heading

I have a sharepoint custom list (a) with a date field, the values in this field are derived from a separate list of dates,(b) using a drop down list, I need to group the list entries for list(a) by ...
2
votes
1answer
157 views

How to convert date based on current users, using client side code

I have a date that I want to display to the user, and the format should be dynamic and based on the user. If I do this I get a format that doesn't fit every user. var prettyDate = ...
2
votes
0answers
21 views

Different Times between View and DisplayForm in Calendar

The setup: I am using a default Calendar list in SharePoint 2010 Enterprise. The calendar is being used to track meetings in for a specific meeting room. The calendar has content approval required ...
1
vote
0answers
8 views

Why does the time-date for document set members differ from the document set time-date after a move

When moving a document set from one library to a Records library via a modified ootb approval SP2010 workflow, the docset has the correct CST date and time, but its document set members are 6 hours ...
2
votes
1answer
230 views

KQL for date range

I've a managed property datetime and i try to use a search for having the result in range. The issue is that i don't know how to format the date myManageProperty=01/02/2014..17/02/2014 but i don't ...
0
votes
1answer
27 views

Date Time ins LIST

I Have a list (Orders list) where i have a column "CreationDate" as internal name. That column stores datetime of the order. When I show this column in a View, it appears in the format "dd/mm/yyyy" ...
0
votes
1answer
172 views

Calendar working days - set start and end days to sunrise and sunset

Can the working day of a calendar be set to the sunrise/sunset? I found javascript to calculate sunrise and sunset given a date and lat/long info. This would calculate the sunrise/sunset of the ...
0
votes
2answers
85 views

GetFieldValueAsText DATE plus 1 hour

I have a GetFieldValueAsText converting DATETIME with 1 hour plus: 29/01/2014 14:26:45 after GetFieldValueAsText I get 29/01/2014 15:26 Someone can help me? Thanks
0
votes
2answers
287 views

Formula to show differens between dates without weekends and holidays

If anyone know formula without code in SharePoint 2010 to show differens between dates without weekends and holidays, I'm trying to find solution but no result so far ... I will be veru gratefull for ...
3
votes
3answers
150 views

Get difference in Minutes for DateTime format column

I have a formula for calculated column which gets the date difference in hh:mm format. =TEXT([COLUMN2]-[COLUMN1],"h:mm") But I want to get the difference in just minutes. I created very complex ...
0
votes
1answer
18 views

Problem Applying a formula to a column in via additional column settings

SharePoint Version is SharePoint 2007 standard Scenario: I'm trying to apply a forumla from within the additional colum settings of a date/field data type. In particular, one that'll return the text ...
0
votes
1answer
89 views

SharePoint adds +1 to time when I set it

I have an issue with SharePoint date time field. Basically I have a date time field, and this field contains for example 19/12/2014 11:30:00. I would like to get this date and remove the time part, ...
0
votes
2answers
264 views

Set the range of datetimecontrol

i have 2 DateTimeControl on my aspx page. Is it possible to make that the second one begin at the selected date of the first one and make all the previous dates disabled? I tried this on the code ...
0
votes
1answer
752 views

How to display date in Page Layout in specific format

I am using the following code to display date in a publishing page layout. <SharePointWebControls:FieldValue runat="server" FieldName="Created" id="CreatedOn"/> This displays both date ...
0
votes
1answer
85 views

Show current DateTime as a Survey question

I have a survey list with some questions. I want each survey to have current DateTime. I used DateTime column and set the default value as Today's Date but when i try to respond to survey the column ...
0
votes
1answer
93 views

Sharepoint 2010 itemadded eventreceiver datetime parseexact fails (sometimes)

I have an event-receiver set up for sharepoint that runs a query against Oracle and then parses the returned date string. The SQL SELECT statement is built like this : TO_CHAR (TRUNC (dateinfo), ...
0
votes
0answers
74 views

Wrong date representation on Russian site while filtering by date range using Date Filter Web Part (?)

I want to create date range filtering on my event list. For that I use the following article: List filtering by date range. I was able to follow all the article and connected Date Filter Web Part with ...
0
votes
0answers
115 views

Ways of implementing data range filtering on event list

I have to implement filtering of my event list on several columns like EventType, Organisator and so on. All the columns filtering work well using OOB filtering by pressing on the header of the ...
0
votes
1answer
34 views

New Item Fields Automatic Population

I sure this is possible to do in SharePoint, however, I am not 100% sure on how it's to be done. My objective is to 2 fields to automatically populate when adding a 'New Item' to an List Library. ...
0
votes
1answer
222 views

How to add a calculated column which shows the modified date/time of an attachment?

I have a list where each item has an attachment (or in some cases 2 attachments). I would like to add a "Last modified" column in a view which shows the date/time of the last attachment modification. ...
0
votes
3answers
255 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 ...
2
votes
1answer
226 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 ...
0
votes
2answers
219 views

Set current date i.e [Today] in a list column

I have a requirement where in user wants a column to be populated with Current date i.e Today. I went through many posts and found it is not possible to use Today() in list columns. The reason why ...
0
votes
1answer
150 views

Date Column showing “1/1/1900 5:30 AM”

Have created a custom list with below column 1.Title 2.Status (Drop-down column with "In progress" & "Completed") 3.In Progress Time (Date & Time Column) 4.Completed Time (Date & ...
0
votes
1answer
734 views

Why can't I get this calculated field to work?

I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a ...
1
vote
1answer
277 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 ...
0
votes
0answers
220 views

Modified Date in Explorer view not updated when the file is edited

I modified some Word documents more than a month after they were put into SharePoint. SharePoint shows the updated dates, but the explorer view still has the original file date/time, and the content ...