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

learn more… | top users | synonyms

0
votes
1answer
373 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
828 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
240 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
206 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
685 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
248 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
0answers
8 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
13 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
17 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
40 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
26 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
11 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
74 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
15 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
187 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
59 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
61 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
0answers
56 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
65 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
27 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
155 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
2answers
106 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
1answer
93 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
201 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
942 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 ...
0
votes
0answers
158 views

Conditionally format Date/Time on items greater than 24hours?

I have a calculated field called duration which subtracts the modified date/time from the created date time. I'm trying to created a conditional format in designer which highlights item rows if the ...
0
votes
2answers
184 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
0answers
79 views

Create datetime variable from date and time values

I have the following problem : I need to create a variable storing a datetime value based on the value of 2 separate variables coming from an infpath form, one contains the date and the other one ...
0
votes
0answers
78 views

Intermittent calculation failures in calculated date column WSS 3.0

Little late in the game to still be asking WSS 3 questions but I'm stuck with Project Web Access 2007 so that's what I have. I created a calculated column in a document library to give me the Week ...
0
votes
1answer
28 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
0answers
68 views

SharePoint 2010 Calculated Date: Monday of the current week

I want to have a date column in a list that will auto-populate to Monday of the current week. So, for example, say I was adding an entry to the list today, Tuesday, June 11 (6/11/2013). The date ...
0
votes
1answer
39 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
0answers
224 views

KeywordQuery returning wrong dates (date - 1 day)

I'm using a KeywordQuery in my SharePoint to get the list of tasks for a particular user, it works very well, only one thing that is going wrong is the date. Basically above of that webapart with ...
0
votes
1answer
283 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?
0
votes
0answers
40 views

A reusable 2013 Workflow is not updating a date field which is marked as required

Good Morning, I have a date field in a SharePoint 2013 list that is marked as required. I need to update it to add the number of days in a payment terms field in a separate list. The target field ...
0
votes
0answers
182 views

Convert Local Time (SSRS datetime parameter) to UTC Time

I am working with SSRS 2008 and SP 2010. My report has 2 parameters 1. TimeZone this parameter is read from SharePoint site (timezone of the site as per regional settings) the other is simple datetime ...
0
votes
2answers
149 views

Validat Data on Date And Time Column not work on editform.aspx on sps 2010

i have a pronlem on validation on edit mode of list items. my a simple list have a column named : "StartTime" with date & time type. and i add this validate rule : "=[Created]<[StartTime]" it ...
0
votes
1answer
80 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
249 views

Date column value changes because of DST

A list includes a column "Date" of type Date and Time, Date and Time Format is Date Only. An item is saved via web-service and is set to value such as 2013-04-01T00:00:00Z. When this same item is ...
0
votes
1answer
632 views

Designer Workflow: “Find Interval Between Dates” action not working

I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the ...
0
votes
1answer
91 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
166 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
2k views

Check for empty date in SPD Workflow

Question How can I check for an empty date condition in a SharePoint Designer Workflow? Background I have a list called "Project" with multiple date fields. I have a calendar called "Project ...
0
votes
1answer
96 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 ...
0
votes
1answer
147 views

Daily and weekly alerts always send

I have created sharepoint alerts programmatically. If I check 'manage my alerts' all values are correct such as "Weekly", "Friday", "6:00pm" then I add an item to the list and receive an alert email ...
0
votes
1answer
126 views

SearchCoreResult returns Regional Date Value

I got the following formate returned from "Write" in english: <write>09/12/2012</write> I parse that with the following line and return a german format: 12. Sep. <xsl:value-of ...
0
votes
1answer
160 views

Want my column display minutes and want it to sum in hours

I have an issue again... I create list from csvfile. I convert string with date into DateTime type like this: string[] formattedDates = { "dd.MM.yyyy HH:mm:ss", "mm:ss", "HH:mm:ss", "dd.MM.yyyy", ...
0
votes
1answer
164 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
0answers
2k views

Set Due Date using a Workflow for a date 2 days after the item was created

Running into trouble using Designer. I need my workflow to set the due date for 2 days in the future but it will only let me set today's date or a specific date as the value.
0
votes
1answer
377 views

Having problem inserting JQuery Date into List

The situation I am using the Time Picker Addon (http://trentrichardson.com/examples/timepicker/) to allow user to select a date in the format of YY-MM-DD HH:MM:SS. The date is insert into a ...