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

learn more… | top users | synonyms

0
votes
1answer
243 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
3answers
325 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 ...
2
votes
1answer
258 views

SharePoint Bug? Conflict Error when saving a Page with a “Required” DateTime field in the page layout

I've just recently encountered a weird error / bug in SharePoint. Here is the scenario: I have a custom column "Test Date" that is of DateTime field type. The field is configured as required. It is ...
0
votes
2answers
259 views

Set current date i.e [Today] in a list column

I have a requirement where in user wants a column to be populated with Current date i.e Today. I went through many posts and found it is not possible to use Today() in list columns. The reason why ...
0
votes
1answer
175 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
933 views

Why can't I get this calculated field to work?

I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a ...
1
vote
1answer
329 views

How to default a date field to a particular day of the week?

When a new list item is added, I'd like a date field (Date From) to be defaulted to Monday of this week, as well as another date field (Date To) to Sunday of next week (creating a 1 week span ...
0
votes
0answers
237 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
2k 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
1answer
236 views

Pulling current date in formula builder returns wrong date

I am trying to pull the current date in MMDDYY format from infopath so I can use concat with some other fields to autogenerate a request number, but I am receiving the incorrect date. If I just use ...
1
vote
0answers
227 views

Calendar Start and End Dates not correct

I am having trouble with out SharePoint calendar. I have some calculated columns set up to display start and end times for anything that is not an all day event (based off the guide here), but some ...
0
votes
1answer
1k views

How to format Date in Content Query Web Part?

I have a CQWP in which I am querying the data from a document library. ItemStyle being used is "Title and Description" Title displays the title of the Document and the in Description I have given a ...
1
vote
1answer
97 views

Highlight items older than X

I have a list which 4 statuses. New, claimed, pending and completed. I need to highlight items which are in the new status for longer than 3 hours. I've read that using the =today() function isn't ...
0
votes
1answer
45 views

ETA Field Validation

I have a list which has an ETA data/time control. I'm trying to figure out a way to prevent users from entering a date which is before the current date/time?
0
votes
2answers
384 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 ...
1
vote
0answers
108 views

Date and time in SharePoint News Archive List

I have the following method which gets the old news items and displays in the archive page. I am displaying the old news items by month wise. User will click the Month URL and then he can see the ...
4
votes
2answers
3k views

Format Date using Javascript Object Model

I am using the javascript object model to get a date field back and display it on a page e.g. oListItem.get_item("MyTestDate") This displays on the page by default as: Thu Jul 25 09:30:07 PDT 2013 I ...
1
vote
1answer
138 views

Alert based on due date

I am looking to create an alert to a user based on approaching a due date. example, Mr Jones (the doc owner) will get an alert 30 days before his document needs to be reviewed. I have looked ...
0
votes
2answers
115 views

Keyboard shortcut to Insert 'Today's Date' in SharePoint 2010

Does anyone know if there is a keyboard shortcut to insert 'Today's Date' in a Date field in SharePoint 2010? I've looked at the Microsoft Office SharePoint 2010 Keyboard Shortcuts and I do not see ...
2
votes
1answer
26 views

Weekly Date Intervals

I am trying to get weekly start and end dates displayed automatically (as i am going to be pulling reports weekly, this will be helpful). For example, if today was monday 6/24 - would like to pull ...
1
vote
2answers
141 views

List validation on sharepoint 2010 list

I tried to add validation on sharepoint 2010 list to validate 4 columns but, the length of this validation is greater than length of text box to write the formula. Is there any way to expand this text ...
0
votes
1answer
31 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
49 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" ...
1
vote
1answer
236 views

Converting date from utc to regional setting (cultural info) of the site

I have a question, basically i have a date time which is by default in UTC, how do i programmatically convert it to a correct date time in regional settings of the site collection / or user?
0
votes
0answers
288 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
415 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
1answer
849 views

TEXT formula does not work in SharePoint 2010

I try to find difference between two date and time value in SharePoint 2010. I have two common column (date and time) and I use this formula =TEXT(Column2-Column1,"h:mm:ss") but it does not work? I ...
1
vote
2answers
113 views

Create SPList Metadata

I want to give a SPLists a Expiry Date so they are later deleted through a timerjob. The value is set by the user when they create a list through my functioning visual webpart. Is it possible to give ...
1
vote
3answers
340 views

Calculate the difference between system columns Created on and Modified on

I'm trying to create a new column in a shp list that contains the difference in days between two other columns in that list. These two columns are the custom list columns that contain the date Created ...
0
votes
2answers
176 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 ...
2
votes
1answer
231 views

Access Uploaded Document's Original Creation Date in SP2010

I've spent some time searching this site and others but haven't seen a conclusive answer to this question: is there a non-code way to display the original creation date for an Office document in a ...
1
vote
1answer
287 views

SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?

I have this XML query that pulls all entries and fields from a SharePoint list. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> ...
0
votes
1answer
118 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
3k views

How to determine business days in sharepoint workflow

One step of my workflow needs to calculate how many BUSINESS days i have between two dates. The problem is that my customer registers the holidays in a sharepoint list. So i will need to query this ...
0
votes
1answer
357 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
1k 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
104 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
227 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
2answers
562 views

Showing only last six months in a dropdown

I have a month column (a choice column) in my document library. Its format is, for example, "Jan 2013". I have the following requirements: The month dropdown should always show only the previous 6 ...
2
votes
1answer
265 views

How would I take a date field and subtract 30 days to show the month prior to the original date

I have records that are modified each month. The site is used to display the previous month's information. However, to make sure that the information is correct, I want to use the date the ...
0
votes
1answer
3k 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
113 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 ...
1
vote
1answer
1k views

sharepoint date column calculation

This is my first day using SharePoint and I was lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I am using SharePoint 2010. I ...
1
vote
1answer
1k views

Date column showing as “Date and Time” even though “Date Only” selected

In a workflow I have set up on a list, the email that is generated is showing a date with both date and time, with the time at 12:00:00 AM (using a lookup of one of the list's columns). Checking the ...
2
votes
1answer
184 views

Calculating dates in sharepoint list

I have two columns in a list, one called 'start date' and one called 'renewal date' what I need is for the renewal date to default to a year after the start date, i.e. Start date = 07/09/2013 and for ...
0
votes
1answer
570 views

Issue using ddwrt:FormatDateTime in xsl variable

I have a data view and am trying to filter using 2 date filter web parts. I'm assigning the date filter values to parameters ($StartDateFilter and $EndDateFilter). I'm struggling with the filter data ...
0
votes
1answer
183 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
505 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 ...
1
vote
0answers
165 views

How to make report in SharePoint 2013?

I am trying to make Report of Time registration part in SharePoint 2013. And I try to use Access View but SP 2013 doesn't have Access view or I didn't find out it. If you have any advice or suggestion ...
1
vote
0answers
51 views

Combine 2 seperate date and time columns into one

I have 2 separate columns in a list document library one is date and one is time can they be combined with a calculated column? If so how? Thanks Lewis