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

learn more… | top users | synonyms

1
vote
1answer
719 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
182 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
296 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
74 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
532 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
139 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
898 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
232 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
0answers
6k 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.
1
vote
0answers
96 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
7k 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
2answers
40 views

Convert Choice field value into Date format using Calculated column

I have a choice column in which choices are name of months. I want a calculated column which returns me the date format data. Choice Column | Calculated Column ----------------------------------- ...
0
votes
1answer
266 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
3answers
3k 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
3answers
6k 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
24 views

Trying to make a difference between two dates, with days, hours and minutes

I try to make a difference between two dates, but displaying the days and hours. So I found a good idea on this website : ...
0
votes
1answer
3k 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
60 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
459 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
2answers
129 views

How to remove the seconds part from a date and time property

We have a standard Calendar app in SP2013 with some events that we roll up on a homepage using a content search web part (the Two Lines display template). We show two properties: the title and the ...
0
votes
3answers
88 views

sort on month and year

In my custom list i have columns month and year. Both are string column. This is my query to get data Query = @" <Where><And><Eq><FieldRef Name='Status' /><Value ...
0
votes
1answer
2k 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
502 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
34 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
435 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
298 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
633 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
549 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
14 views

Validation Error When Submitting Custom Infopath Form on Sharepoint List

I recently created a new list for our employees to create new Goals using sharepoint. I created a content type called “annual performance goals” and created a custom new entry form using infopath to ...
0
votes
1answer
26 views

KQL - How to Create Query That Filters by Dates Within the Past Week (7 Days)

So I'm trying to create a query using KQL where one of the parameters brings back items that fall under a certain date range - only items that got modified within the past 7 days. Here it is below: ...
0
votes
1answer
52 views

Process DateTime field value in SharePoint List Edit form

I am working on a Item Update event receiver in a SharePoint document library. One of the fields in this library is a Date and Time (Date only format) field. When a user selects a date and clicks on ...
0
votes
1answer
77 views

How to remove time stamp from date field in InfoPath form?

I have a drop down in an InfoPath form that grabs data from a SharePoint list. One of the fields in the form is a date field and when it gets populated with the date from SharePoint it includes the ...
0
votes
1answer
180 views

Format Created Date and Modified Date Columns to Display Normal Time

I have a PowerShell script that outputs to CSV all items and files from all Lists and Libraries below: function Get-DocInventory([string]$siteUrl) { $site = New-Object Microsoft.SharePoint.SPSite ...
0
votes
1answer
28 views

InfoPath Calculated Date

I am trying to have the Calculated Date field be the first of the month, the month before Start Date. This works when the Calculated Date month is double digit but breaks on single digit months. Any ...
0
votes
1answer
66 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
44 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
139 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
429 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
287 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
52 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
500 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
392 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
135 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 ...
0
votes
1answer
120 views

DATEDIF in Workflow

Is it possible to use DATEIF inside a workflow? Right now I have: =DATEDIF(TODAY(),[Expiration Date],"D") Is this possible inside a workflow if? is there a certain benefit to it? Thanks.
0
votes
2answers
1k views

Set default date based on date other date column

I'm fairly new to SharePoint and I'm still learning the terminology so please excuse I have 2 Date Time columns in a SharePoint list, Date Received and Due Date. The Due Date is supposed to be 30 ...
0
votes
3answers
180 views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...