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

learn more… | top users | synonyms

1
vote
6answers
108 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 ...
0
votes
1answer
140 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
87 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
211 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
69 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
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 ...
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
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
287 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
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
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 ...
0
votes
1answer
54 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
348 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
302 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
93 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
257 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
134 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
329 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
147 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 ...