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

learn more… | top users | synonyms

1
vote
6answers
112 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 ...
1
vote
1answer
339 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
0answers
35 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start ...
1
vote
1answer
72 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
0answers
12 views

Why does the time-date for document set members differ from the document set time-date after a move

When moving a document set from one library to a Records library via a modified ootb approval SP2010 workflow, the docset has the correct CST date and time, but its document set members are 6 hours ...
1
vote
0answers
358 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 ...
1
vote
1answer
196 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 ...
1
vote
0answers
162 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 ...
1
vote
1answer
265 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 ...
1
vote
1answer
682 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
609 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> ...
1
vote
0answers
178 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
52 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
0answers
237 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 ...
1
vote
0answers
72 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 ...
1
vote
2answers
427 views

CAML Query List by months

I was wondering if i have 3 random dates. 11/12/2012 9/24/2011 12/29/2008, I'd like to have September 9/24/2011 November 11/12/2012 December 12/29/2008 instead of using the query to sort by ...
1
vote
1answer
117 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 ...
1
vote
1answer
2k views

Using a date column in a sharepoint online web chart web part

I added a "web chart" web part to a sharepoint online page from the browser interface. Next, I decided to run the Data connection wizard to connect my chart to an excel services. In the step 3 of ...
1
vote
1answer
746 views

Validation of dates in different fields in sharepoint

My question is on validation of dates in SharePoint… If i have two date fields – start date(& time) and end date(&time). How do i validate these, so that a person cannot pick a time in ...
1
vote
0answers
228 views

Week number formula for date and time column

What calculated field formula would show me the week number for a date and time like this: 5/27/2012 6:00 AM All the formulas I found are only for dates.
1
vote
2answers
1k views

ddwrt Schema Unavailable?

So: I'm trying to use the ddwrt:FormatDateTime function in an XSL transform, but I'm getting the following error: Exception details: Method: ...
1
vote
0answers
94 views

Why does Search only accept YMD date format when Search Language is en-ca (usually DMY date format)?

For some reason the server thinks that the date format for English (Canada) is YMD or yyyy/MM/DD, and the server will only correctly read queries with that format. However, the default short date ...
1
vote
2answers
1k views

SharePoint Designer: CurrentDate CAMLVariable is incorrect to compare to date column

I am creating a simple form by "Insert Data View" web part and filtering on the data source by date. Something like: Displays all the announcement items that have: "Expires" Greater Than Or Equal ...
0
votes
4answers
5k views

REST service $filter Date column

Using the REST services, I'm trying to filter by the Created column, which is a Date data type. When trying to $filter on that column, I passed in the same date format that comes back in the JSON ...
0
votes
1answer
1k views

REST API filter by month

I would like to filter a datetime field but I only want to filter MONTH var requestUri = "xxxx/getByTitle('Contact')/items?$select=CellPhone,mdate,ddate&$filter= Birthday ge '" + today + "'"; ...
0
votes
3answers
2k views

Formula to show differens between dates without weekends and holidays

If anyone know formula without code in SharePoint 2010 to show differens between dates without weekends and holidays, I'm trying to find solution but no result so far ... I will be veru gratefull for ...
0
votes
1answer
3k 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 ...
0
votes
1answer
83 views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
0
votes
1answer
471 views

sharepoint designer - get current server datetime through javascript REST

Is it possible to get current date time of sharepoint teamsite hosted server through javascript REST api?
0
votes
1answer
59 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
391 views

Saving date on sharepoint profile

I have a method on my code that stores the birthday of users on a Sharepoint profile property (BirthDay). This property only accepts the format "yyyyMMddHHmmss.0Z" so i have the following code: ...
0
votes
3answers
5k views

SPServices <today /> not returning correct results

This is the chunch of code that I am working with. I am trying to get only the events (normal/all day/recurring) to show, and it is returning all items for the whole week. Any ideas? ...
0
votes
1answer
456 views

Updating a list item using date() function

I have a column [ScheduleTime] which is a DateTime type in my List. Using JavaScript i need to update the [ScheduleTime] column which should be Current Day whenever my script loads. But here I need to ...
0
votes
2answers
159 views

JSOM and UTC conversion

I'm using client Object Model to filter a list and display an event date. When displayed I see a UTC date format. How can this be converted to UK date format using Javascript object model? Is it ...
0
votes
2answers
31 views

Are workflows sensitive to data changes?

I want to make a workflow that will move an item from one list to another once the current date exceeds the archive date. I was wondering, do workflows just save the values they are given once they ...
0
votes
2answers
255 views

Insert record with Date into list via JSOM, problem with UK Format

I have found that when inserting a record which contains a Date using JSOM the update(); will not work if you specify the format of the date to be UK date (28/05/2014). The code does not error, it ...
0
votes
1answer
216 views

SharePoint adds +1 to time when I set it

I have an issue with SharePoint date time field. Basically I have a date time field, and this field contains for example 19/12/2014 11:30:00. I would like to get this date and remove the time part, ...
0
votes
1answer
2k 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 ...
0
votes
1answer
487 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 ...
0
votes
1answer
1k 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 ...
0
votes
1answer
521 views

Converting datetime column value to server datetime value

I am trying to build a calendar with date time columns. My SP 2007 server is in US and I am trying to use this site in India. My server returns the EventDate column value in India format. I want to ...
0
votes
1answer
26 views

Address timezone issue while saving or retrieving

I have a SharePoint list having couple of DateTime properties. Currently, we are not manipulating any date-time values when saving list-item to SharePoint. It was working fine but recently we noticed ...
0
votes
1answer
31 views

How to set the release date of a post in SharePoint?

We wish to post something to the SharePoint website, e.g. an announcement, a calendar schedule, etc. But we do not want users to see those posts until the release date. Is there a way to set ...
0
votes
1answer
34 views

Calculated column to find due date

I need to create a calculated column that will read in the date from one column and compare it to today's date. The problem is the the date column is a dropdownlist with dates entered in the format of ...
0
votes
2answers
81 views

Column Validation for day Monday OR Friday

I'm working with a date and time column and need a validation that returns true if the day of the week is Monday OR Friday. Users are not permitted to add an item on any other day of the week. ...
0
votes
1answer
95 views

SP.TimeZone.utcToLocalTime how to use

I'm trying to use SP.TimeZone.utcToLocalTime via REST API, but can't understand which format is right for input (with Date and Time). It works only with date ...
0
votes
2answers
36 views

Problem converting the timestamp 1426593600000 to a date

I am trying to get some calendar items based on the StartTime field. I've done this: /_vti_bin/ListData.svc/MyAgenda?$filter=StartTime%20gt%20datetime%272015-03-16T19:00:00Z%27 This show me the ...
0
votes
1answer
45 views

date column validation

Is it possible to validate the end date to be not greater than by 30 days over the start date? So if the Start Date is February 18, the End Date cannot be more than 30 days past February 18. Thank ...
0
votes
1answer
169 views

CAML query datetime - publishingstartdate

I'm trying to get a CAML query working with dates - specifically PublishingStartDate and PublishingExpirationDate. When scheduling an item, there is the option to select 'immediately' and 'never' ...
0
votes
1answer
34 views

How to specify a specific range of dates

I have a List that tracks certificates. I need to limit two of the input fields and I'm not sure how. I have a formula (=[Expiration Date]>[Last updated]) in place that prohibits an Expiration ...