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

learn more… | top users | synonyms

1
vote
6answers
118 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 ...
3
votes
3answers
93 views

SharePoint DateTime issue when date is saved using CSOM

The timezone set in SharePoint Online is EST and when it is being saved to SharePoint using CSOM/ECMA script from location with UTC +5:30 timezone the date is reduced. Everytime we edit the time is ...
0
votes
3answers
35 views

How to restrict date(Created) field to display only date and time?

How to restrict the date field(Created) to show only date and time instead of Fri Apr 15 2016 16:06:04 GMT+0530 (India Standard Time)? I do not want to show GMT and so on. The below is my code. ...
0
votes
2answers
46 views

Setting End Date to same as start date

I have a list that I created to track start/end times for activities. I'd like to set the form so that when the user enters the start date it populates the end with the same date so that users ONLY ...
1
vote
1answer
10 views

Elapsed time driven Automated Reminder workflow

Am trying to create a workflow (SP 2013) that checks today's date, checks the date an item was created, and if it is a week old, sends an e-mail to to creator saying "we are still working on your ...
1
vote
1answer
47 views

How to filter on System.DateTime using FilteredDataSourcePropertyFormat?

I'm using an SPGridView that displays search results and it works perfectly. Sorting and filtering works fine as well unless for the DateTime Column. When I'm trying to filter by Date I have the ...
1
vote
1answer
44 views

How to capture original creation date of a document while uploading into document library?

I am uploading a document in SharePoint document library and would like to capture original creation date of the document. Can anyone let me know about this? For Eg: If a document is created on 1st ...
1
vote
1answer
162 views

Validating a set of dates in Microsoft Sharepoint

I am trying to validate dates in a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub. I, then, want that [Date of ...
1
vote
1answer
90 views

Content Organizer creates wrong modified date (2013)

We are using Content Organizer feature to route documents from one site collection to another. We have noticed that upon arriving to the destination documents library, each document has wrong modified ...
1
vote
1answer
47 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 ...
1
vote
1answer
765 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
1answer
99 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 ...
1
vote
1answer
859 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?
1
vote
1answer
143 views

Trying to implement a follow up date

We have a calendar in sharepoint 2010 Foundation that we have added some extra columns and workflows but I am trying to impliment a followup date. At the moment all we have done is created a ...
0
votes
1answer
7 views

Time Displaying Incorrectly on InfoPath Form and Not Displaying Current User

I have 2 controls below. The top Text box is labeled CommentsTemp while the bottom TextBox is called Comments. How it works is, when a user enters anything in CommentsTemp, that it would be stored in ...
0
votes
1answer
28 views

REST API datetime range not working as expected

Background: In Sharepoint Online, I'm using the Sharepoint REST API for query a few records based on its creation date (column Created). I'm using the following variations of the REST query for get ...
0
votes
1answer
28 views

How Do I Input Todays Date Into a List?

looking to add todays date into sharepoint list so that I can run multiple expiry timelines off other cells. Have looked online and tried the work arounds but can't able to get any working code. I ...
0
votes
1answer
47 views

Time Difference in SP Calculated Column excluding weekends

I have two dates (Initial Date & End Date) both date and time format in a SP List. I need to calculate the amount of days between both of them excluding weekends. I already have the formula in a ...
0
votes
1answer
120 views

Daylight saving time and UTC

Can someone confirm that using UTC date storage in lists can cause problems after summer time ends? I'm in the UK, during the summertime i was in UTC+1. So when i saved a date field using the ...
0
votes
1answer
45 views

Calculate 70 plus formula

I am trying calculate a UAT 70 day view that adds 70 days to today's date which represented below by the "CalcToday" column minus the UAT START DATE field plus 70 days (mm-dd-yyyy). The formula below ...
0
votes
1answer
216 views

How to calculate the total days between two selected calendar dates

I've startDate = 7/16/2015 and endDate = 7/20/2015. This 2 dates are stored in a SharePoint list. If user select the exact date with the date in SharePoint list, it can calculate the total days = 2 , ...
0
votes
1answer
211 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
1answer
454 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 ...
0
votes
1answer
212 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
409 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
1answer
142 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
1answer
2k 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
1answer
49 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
115 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
394 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
48 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
253 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
74 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
531 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
494 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
33 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
131 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
1answer
403 views

Empty date field goes to 1/1/1900 when updating target list with workflow

Say, I have a SourceList with date fields like these DateReceived, DateEntered. If these field or fields are null then in workflow updates the target list item with 1/1/1900 dates respectively. ...
0
votes
1answer
175 views

All Day Event = False throws a workflow error

I have a workflow item that I am stumped on. It is very basic... 1 If All Day Event equals True 2 Log >SET TIME< 3 then Store [%Date%] in Variable:TimeFrame 4 then Log - OK 5 Else If All ...
0
votes
1answer
458 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + ...
0
votes
1answer
186 views

How can I get a daily hour value from a date/time field?

I am trying to calculate the amount of time on a daily basis. Currently I have calculated "[total hours per diem]", "[total days]" and the time values (if not split over multiple days). Where I am ...