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

learn more… | top users | synonyms

0
votes
0answers
13 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
38 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
47 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
25 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
25 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
38 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
10 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
109 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
18 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
7 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
65 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
24 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
66 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
47 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
72 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
79 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
15 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
68 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
176 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
286 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
57 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
60 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
54 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
61 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
27 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
150 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
2answers
101 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
0answers
148 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
1answer
110 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
91 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
232 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
125 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
199 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 ...
0
votes
1answer
889 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 ...
0
votes
1answer
123 views

Pulling current date in formula builder returns wrong date

I am trying to pull the current date in MMDDYY format from infopath so I can use concat with some other fields to autogenerate a request number, but I am receiving the incorrect date. If I just use ...
1
vote
0answers
169 views

Calendar Start and End Dates not correct

I am having trouble with out SharePoint calendar. I have some calculated columns set up to display start and end times for anything that is not an all day event (based off the guide here), but some ...
0
votes
1answer
803 views

How to format Date in Content Query Web Part?

I have a CQWP in which I am querying the data from a document library. ItemStyle being used is "Title and Description" Title displays the title of the Document and the in Description I have given a ...
1
vote
1answer
58 views

Highlight items older than X

I have a list which 4 statuses. New, claimed, pending and completed. I need to highlight items which are in the new status for longer than 3 hours. I've read that using the =today() function isn't ...
0
votes
1answer
35 views

ETA Field Validation

I have a list which has an ETA data/time control. I'm trying to figure out a way to prevent users from entering a date which is before the current date/time?
0
votes
0answers
158 views

Conditionally format Date/Time on items greater than 24hours?

I have a calculated field called duration which subtracts the modified date/time from the created date time. I'm trying to created a conditional format in designer which highlights item rows if the ...
0
votes
2answers
179 views

Get Elapse time from Created and Modified Columns

I'd like to created a calculated column which subtracts the modified date/time from the creation date/time, is this possible? EDIT: This worked for me - =TEXT(B2-A2,"h:mm:ss") replace the cell ...
0
votes
0answers
79 views

Create datetime variable from date and time values

I have the following problem : I need to create a variable storing a datetime value based on the value of 2 separate variables coming from an infpath form, one contains the date and the other one ...
1
vote
0answers
92 views

Date and time in SharePoint News Archive List

I have the following method which gets the old news items and displays in the archive page. I am displaying the old news items by month wise. User will click the Month URL and then he can see the ...
3
votes
2answers
2k views

Format Date using Javascript Object Model

I am using the javascript object model to get a date field back and display it on a page e.g. oListItem.get_item("MyTestDate") This displays on the page by default as: Thu Jul 25 09:30:07 PDT 2013 I ...
1
vote
1answer
94 views

Alert based on due date

I am looking to create an alert to a user based on approaching a due date. example, Mr Jones (the doc owner) will get an alert 30 days before his document needs to be reviewed. I have looked ...
0
votes
2answers
83 views

Keyboard shortcut to Insert 'Today's Date' in SharePoint 2010

Does anyone know if there is a keyboard shortcut to insert 'Today's Date' in a Date field in SharePoint 2010? I've looked at the Microsoft Office SharePoint 2010 Keyboard Shortcuts and I do not see ...
0
votes
0answers
75 views

Intermittent calculation failures in calculated date column WSS 3.0

Little late in the game to still be asking WSS 3 questions but I'm stuck with Project Web Access 2007 so that's what I have. I created a calculated column in a document library to give me the Week ...
2
votes
1answer
24 views

Weekly Date Intervals

I am trying to get weekly start and end dates displayed automatically (as i am going to be pulling reports weekly, this will be helpful). For example, if today was monday 6/24 - would like to pull ...
1
vote
2answers
123 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 ...
0
votes
1answer
27 views

SQL Select of SharePoint Dates off ? MOSS 2007

Does anybody know what this is about? They seem to be off by a bunch of hours and they look right in SharePoint but not SQL I also see the problem in my Data view Webpart, but it's clearly coming ...