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

learn more… | top users | synonyms

0
votes
0answers
8 views

How to set a default calculated date 36 hrs from “Now”, Excluding Weekdays

I can set the default to =Today+(36/24) but it calculates from 12am. I want it to calculate from the current time, so 36 hrs from Noon or after would be 2 dates ahead. Ideally, I would also like to ...
1
vote
1answer
20 views

Seconds since item created with REST. Perhaps use server current time (clock)

I'm trying to find the most correct way to determine the amount of seconds since an item was created. My first approach is to simply diff the Created property with the browser time, e.g., ...
0
votes
1answer
31 views

Updating a list item using date() function

I have a column [ScheduleTime] which is a DateTime type in my List. Using JavaScript i need to update the [ScheduleTime] column which should be Current Day whenever my script loads. But here I need to ...
0
votes
1answer
10 views

How To Get Current Date In Long Date Format in a Site Workflow

I have a requirement to get the day of the week into a workflow variable in a SharePoint Designer Site Workflow. This means I do not have a "Current Item" that the workflow runs on. How can I ...
0
votes
2answers
23 views

Changing just the year for all rows in a date column

As the title says I need to change the year for all rows in a list to 2015 from 2014 but leave the month and day the same for each. Had this been built as a calculated date column it would be much ...
1
vote
0answers
18 views

Odata Queries and Date Fields

I have a calculated field that contains the logic if(date) {Yes;} else {No;} This works fine for the column's calculation, but I either need to get the result of the calculated field or need to ...
0
votes
0answers
18 views

CAML query to Filter data on “DateTime” on a sharePoint 2007 list

I am trying to create a web part as a report to filter list data based on date and time I've created CAML as follows <Value IncludeTimeValue='TRUE' Type='DateTime'> Further I've ensured ...
1
vote
1answer
44 views

Workflow not behaving correctly

I have a work flow that fires off email notifications at specific dates, based on the number of days between the Expiration date and Today. It works up until a user goes to change the date of the list ...
0
votes
1answer
19 views

DATEDIF in Workflow

Is it possible to use DATEIF inside a workflow? Right now I have: =DATEDIF(TODAY(),[Expiration Date],"D") Is this possible inside a workflow if? is there a certain benefit to it? Thanks.
0
votes
1answer
30 views

How to validate on an absolute date?

I have a datetime field named "Date", and would like to only allow values within a specific range, say March 2015 - June 2016. Is there an easy way to do this? This rather hard one doesn't trigger any ...
3
votes
2answers
65 views

REST $filter when comparing 2 date columns causes error <nativehr>0x80070057</nativehr><nativestack></nativestack>

I'm using the on prem SharePoint 2013 REST API and I'm getting an error when I try to compare two date fields. $filter=ExpectedDelivery gt NeededBy The above query works perfectly using ...
0
votes
2answers
49 views

JSOM and UTC conversion

I'm using client Object Model to filter a list and display an event date. When displayed I see a UTC date format. How can this be converted to UK date format using Javascript object model? Is it ...
0
votes
0answers
25 views

How to retrieve the ISO/original value of a DateTime column in a list using CAML?

I'm using SharePoint Foundation 2013 and I want to retrieve the data in my DateTime column. Is there a way to retrieve the original/raw values or ISO values of a DateTime column using CAML query? ...
0
votes
0answers
28 views

SP 2010 TEXT Function Subtracting 1 hour

I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as hh:mm but for some reason the output of the function is ...
0
votes
0answers
13 views

datasheet view: colons instead of dots in time columns

I have a calendar in datasheet view on a Sharepoint 2013 site. When I enter a new calendar item and fill the "Start Time" and "End Time" , the time is not picked up correctly (from the time picker) ...
0
votes
1answer
146 views

REST API filter by month

I would like to filter a datetime field but I only want to filter MONTH var requestUri = "xxxx/getByTitle('Contact')/items?$select=CellPhone,mdate,ddate&$filter= Birthday ge '" + today + "'"; ...
0
votes
0answers
17 views

Search in SharePoint 2013 by CreatedDate is not working

Search in SharePoint 2013 by Created Date is not working in advance search web part. I have created the site column in document library "ReviewExpirationDate" add data in it . after that full crawl ...
0
votes
2answers
106 views

Set default date based on date other date column

I'm fairly new to SharePoint and I'm still learning the terminology so please excuse I have 2 Date Time columns in a SharePoint list, Date Received and Due Date. The Due Date is supposed to be 30 ...
0
votes
1answer
134 views

sharepoint designer - get current server datetime through javascript REST

Is it possible to get current date time of sharepoint teamsite hosted server through javascript REST api?
0
votes
2answers
27 views

Are workflows sensitive to data changes?

I want to make a workflow that will move an item from one list to another once the current date exceeds the archive date. I was wondering, do workflows just save the values they are given once they ...
0
votes
0answers
26 views

date time control sharepoint isdateempty select to date

When I use date time control and use isdateempty, control select today's date as by default. But i want to keep it as emply. Please let me know where I am wrong
1
vote
1answer
40 views

DATEDIF statement in SharePoint not working properly

I am trying to calculate the amount of days between two dates but my formula doesn't seem to be working properly. It's as is the function is ignoring the years in the dates. My function is as follows, ...
1
vote
2answers
52 views

How to trim down date to example 2014-10-10?

How can i trim down date from this Fri Oct 31 2014 01:00:00 GMT+0100 (Västeuropa, normaltid) to this 2014-10-31 on my get_fieldValues i think i can use .setDate.getDate()+ 1).toISOString().substr(0, ...
1
vote
1answer
50 views

Sending user's input from JavaScript into date filter webpart

I want to do date filter for one field in my external list using calendar in order to hep user input date value. Since drop-down calendar in date filter web part doesn't work (i don't know why, when ...
1
vote
6answers
98 views

What functionality and API may be affected by DST and TZ changes? What to test?

As the 2014 RTZ datetime changes weren't implemented smoothly by SharePoint, let's brainstorm on what has and could go wrong with another change like that. So the question is: what test cases to ...
1
vote
1answer
104 views

Showing 1 Minute increments in time field with Sharepoint 2013 list

My company requires our list drop downs to contain time in 1 minute increments. Is there an OOB option I can update to change this? If not, are there any options without installing a third party ...
1
vote
2answers
303 views

Field Modified shows date, but no time

In a view of a document library I have the field "Modified" and this is showing only dates but no time. I would like to display the time aswell. From my understanding it is ill advised to alter this ...
0
votes
1answer
60 views

How can I align Date modified with Date last saved?

I still have this problem with Sharepoint 2010 and Windows 7, i.e. Excel or Word documents edited from within Sharepoint display an outdated Date modified in Windows Explorer view. However, the 'Date ...
1
vote
0answers
29 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
31 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
42 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
13 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
57 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
102 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
32 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
37 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
68 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
135 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
94 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
86 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
35 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
144 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
63 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
8 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
116 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 ...
1
vote
1answer
622 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
126 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
28 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
55 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 ...