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

learn more… | top users | synonyms

1
vote
0answers
35 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start ...
0
votes
3answers
39 views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
0
votes
1answer
75 views

How time is save on list item and its versions?

Today I faced interesting issue: I retrieved list item, saved its modification date to datetime object and and started to iterate through that list item's versions. In first iteration i tried to ...
0
votes
0answers
19 views

Generate a Due Date that exclude business days with a set time period

I've yet to find a simple answer or formula to use. I've a list where I enter when new employees join that will be used to track what training they take. I need a basic due date that is set 30 days, ...
0
votes
1answer
90 views

How to get Month Name from DateTime vlaue in CAML

I have a requirement to show user Month name of the date on which user uploaded the file. My date time value is coming in dd/mm/yyyy 00:00 AM. Someone please help me how to move forward on this.
0
votes
1answer
215 views

Saving Publishing Page in edit mode returns “Are you sure you want to leave this page?” dialogue

we're getting some ... interesting ... behavior in IE. Setup We have a page layout based on some content type. Both contain (besides other fields) a DateTimeField which is shown in edit mode. When ...
0
votes
0answers
34 views

Date and Time in SharePoint 2013

I have imported a list in SP 13. It has a column date and time in it. The column is converted as Single line text in the list, Now I want to convert that into DATE and TIME without TEXT formula. Can ...
0
votes
0answers
68 views

Removing “Due Date” from approval workflow form

Is it possible to completely remove the "Due Date" label from the approval workflow form? My customer does not use explicit due dates, and thinks it is confusing that the label for one even exists. I ...
0
votes
2answers
129 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 ...
1
vote
2answers
174 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
1answer
157 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 ...
0
votes
1answer
271 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
0answers
41 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 ...
2
votes
1answer
215 views

Where is the mistake in workflow?

I have the following issue. To make the automatization of the process I need to fix the date & time for each process step. First I used the calculated column but it didn't work. I found suggestion ...
0
votes
1answer
71 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
10 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
181 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 ...
2
votes
1answer
1k 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
147 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
29 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
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
1answer
62 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 ...
5
votes
3answers
6k views

REST API filter by start and end dates using 'today'

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
1k 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
2answers
42 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
4answers
1k 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
188 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
1k 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 ...
1
vote
3answers
304 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
2k 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
40 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
1answer
776 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
143 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
76 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
48 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
118 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 ...
2
votes
1answer
327 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
28 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
10 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 ...
3
votes
1answer
944 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
56 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
291 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
174 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
3answers
2k 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 ...
4
votes
3answers
1k 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
28 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
189 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
565 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
2k 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
148 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 ...