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

learn more… | top users | synonyms

0
votes
1answer
207 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
208 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
89 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
44 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
0answers
167 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
326 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
90 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 ...
1
vote
0answers
103 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
125 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
103 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
133 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
48 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
206 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
271 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
361 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
813 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
111 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
301 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
165 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
198 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
254 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
104 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
2k 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
324 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
889 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
101 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
214 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
509 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
217 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
106 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
975 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
918 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
181 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
545 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
170 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
462 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
162 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
1
vote
2answers
1k views

CAML OffsetDays

please help if it possible that CAML OffsetDays is not working in DvWP? I use the following CAML within a DVWP: <View><Query> <Where><And> <Lt> <FieldRef ...
4
votes
1answer
65 views

Boundaries in diagram with Date as X

I've recently been trying to build a line diagramm webpart with dates as X Problem is: I can't find a way to adjust the boundaries of the diagram which causes it to start in ~1900 At the moment it ...
1
vote
0answers
148 views

SOAP returns DateTime with timezone offset added to minutes

I am using the Ruby gem 'viewpoint/spws' (from a RHEL 6 server) to insert items into a Sharepoint list via SOAP. It seems that the DateTime fields being passed are being incorrectly interpreted by ...
2
votes
2answers
115 views

Getting latest datetime from a splist

I have sharepoint list with data and one of the columns contains date ... how can i programmatically retrieve the latest date, the field is a Date And Time type?
2
votes
4answers
574 views

Issue with Sharepoint DateTimeControl

DateTimeControl is inside grid and I bind the grid inside !ispostback section, on row databound of grid I find that datetimecontrol and disable it. When button click event (outside of grid), the ...
1
vote
0answers
66 views

Wierd format of Modified date and PublishingStart

Iam having trouble with date formats of these two fields: Modified and PublishingStartDate. They are different in format. Iam attaching how they display on my computer. I have regional settings set to ...
2
votes
1answer
379 views

FormField value set with javascript, value lost on postback

I have a custom list of "requests" which need to accommodate a required time range for a single date (among other fields), so I added "start" and "end" columns of date and time type. I used designer ...