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

learn more… | top users | synonyms

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 ...
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
2answers
86 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
1answer
766 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
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
3answers
262 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 ...
0
votes
2answers
221 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
211 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 ...
0
votes
2answers
330 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
2answers
103 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
1answer
2k views

How to determine business days in sharepoint workflow

One step of my workflow needs to calculate how many BUSINESS days i have between two dates. The problem is that my customer registers the holidays in a sharepoint list. So i will need to query this ...
0
votes
2answers
516 views

Showing only last six months in a dropdown

I have a month column (a choice column) in my document library. Its format is, for example, "Jan 2013". I have the following requirements: The month dropdown should always show only the previous 6 ...
0
votes
1answer
548 views

Issue using ddwrt:FormatDateTime in xsl variable

I have a data view and am trying to filter using 2 date filter web parts. I'm assigning the date filter values to parameters ($StartDateFilter and $EndDateFilter). I'm struggling with the filter data ...
0
votes
1answer
465 views

Calculated Column Incorrect when All Day Event is selected

I've created a Calendar list. I've added a single calculated column ("Calculated Start Time") that simply references the "Start Time" column. It reports the correct date when the event is not an all ...
0
votes
1answer
935 views

How to check DateTime condition in CAML Query?

I want to fetch the records from List which are created in Last 5 minutes. I have written following code, but its not working. giving me error. <Geq><FieldRef Name='CreatedDate' /> ...
0
votes
2answers
254 views

SQQuery, Dates and Regional Settings

First, some setup: My Site is set to Eastern Time, and the server is located in Eastern Time. I'm trying to run a query against a list using the created date. I have tried using all variations I can ...
0
votes
1answer
230 views

When is 'Article Date' populated?

I'm looking at different date fields of a Page I can use and have noticed there's an Article Date column under Publishing Columns. At what point is this column populated?
0
votes
1answer
733 views

Date and time column in Custom List form

I have created a Date and time type column in my custom list and have selected "Date Only" for Display format, but it is always displaying the options to select data as well as time on the form. ...
0
votes
1answer
267 views

Calculate Time Passed After Item Created Using Javascript (or other)

I have a list that tracks loaned equipment. I want a little icon that is a visual indication at how long the item has been on loan to help visually cue employees to follow-up. For example: 0-4 ...
0
votes
1answer
12 views

SP Caml Query Date Range

I Have a List Called Alerts with two columns as Start Date and End Date I am Trying to generate a CAML Query that retrives only cloumns for which alerts should display within that DATE range compare ...
0
votes
0answers
4 views

Timer Thread Method not executing properly

I have a method that refreshes a grid view, I need to run this method on a page every 60 seconds. To do so I have implemented the following timer thread: var timer = new System.Threading.Timer( ...
0
votes
1answer
11 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
0answers
15 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 ...
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 ...
0
votes
1answer
154 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
27 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] ...
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
36 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
38 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
179 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 ...
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
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 ...
0
votes
1answer
176 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
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
2answers
266 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
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
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
118 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
1answer
154 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
0answers
223 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
2k 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
0answers
167 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
0answers
90 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 ...
0
votes
1answer
31 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 ...
0
votes
1answer
48 views

How to provision a File with a DateTime Property set on [today]?

I'm able to provision a file in a document library via a module like this : <Module Name="myModuleName" SetupPath="SiteTemplates\BLANKINTERNET" Url="Pages" > <File Path="default.aspx" ...
0
votes
0answers
271 views

KeywordQuery returning wrong dates (date - 1 day)

I'm using a KeywordQuery in my SharePoint to get the list of tasks for a particular user, it works very well, only one thing that is going wrong is the date. Basically above of that webapart with ...
0
votes
1answer
365 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
2answers
167 views

Validat Data on Date And Time Column not work on editform.aspx on sps 2010

i have a pronlem on validation on edit mode of list items. my a simple list have a column named : "StartTime" with date & time type. and i add this validate rule : "=[Created]<[StartTime]" it ...