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

learn more… | top users | synonyms

0
votes
1answer
12 views

Time variables with SharePoint Designer Workflows

I there a way to set up set up a workflow variable or condition to find [TODAY] - 180; using SharePoint Designer? Update: Would using this in SharePoint designer work for finding list items 180 days ...
0
votes
1answer
53 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
2answers
68 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
1answer
174 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
30 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
28 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
98 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
866 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
102 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
305 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
245 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
228 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
369 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
111 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
550 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
563 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
491 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
962 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
258 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
181 views

Capturing Multiple Time Zones in Sharepoint

I need to capture multiple time zones in our Sharepoint site. Ideally I would like to enter AEST and have the other files calculate/convert to the various other timezones. Is there a way I can do ...
0
votes
1answer
236 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
743 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
271 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
17 views

Managed Property Search Result DateTime is delayed by 1 day

I have a managed property that is having problems with date. The field is set to DateOnly. The item always uses Date-1 . Here is a similar question, Search returns wrong date (date -1) and have a ...
0
votes
0answers
10 views

formatted “Date Only” Date&Time field reveals random hour set inside

I have a list of simple out of office events, each one has a Start Date and an End Date - both Date&Time fields set to Date Only. I displayed those events in a calendar view and to my surprise ...
0
votes
1answer
17 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
5 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
21 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
33 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
16 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
285 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
31 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
22 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
42 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
40 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
243 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
49 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
202 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
19 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
286 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
87 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
78 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
148 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
239 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
168 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
232 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 ...