The date tag has no wiki summary.
4
votes
1answer
42 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 ...
3
votes
1answer
65 views
formula to limit date entries to specific month
In my "time off" custom list I have start date and end date. I want to make the user splits up the entries if the time off spans months. In other words if the entry starts Oct 25 and ends Nov 5 I want ...
2
votes
1answer
100 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 ...
2
votes
1answer
100 views
Problems adding Date & Time values to a comparison using IF in a calculated column
I'm trying to compare a date by using =if([Modified]<DATE(2012,2,8),"Outdated","Updated") and it works just fine, but I have a problem with trying to add time to the comparison.
What I need is to ...
2
votes
2answers
69 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
1answer
275 views
Set date field in newform to selected date on calendarview
I'm looking for a solution where I first select a date on the calendar-view, when I add a new item, the selected date should be filled in on a field in my newform.aspx.
Is this possible out of the ...
1
vote
1answer
108 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 ...
1
vote
1answer
21 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
408 views
Sharepoint Designer add time to date action
Is there any documentation on how SP adds time to a date? For example, if I add one month to today (say it's the 31st), does SP return the last day of the next month (the 30th)? What about leap years? ...
1
vote
1answer
86 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
1answer
50 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 ...
1
vote
2answers
204 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
62 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
561 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
0answers
71 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 ...
0
votes
3answers
704 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
45 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 ...
0
votes
2answers
128 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 ...
0
votes
1answer
130 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
6 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
17 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
73 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
53 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
0answers
64 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
0answers
53 views
SP 2007 - show 5 newest items, based on date column
Trying to create a view that contains yearly data from 2008 but only want to display the 5 most recent years up to the last item. I always want the view automatically sorted from oldest to newest ...
0
votes
1answer
215 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
78 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
0answers
25 views
How to alter an existing report's format in Sharepoint
I have inherited some Sharepoint reports that weren't properly tested before signoff so the date is represented as serial number format rather than date format.
I'm not a programmer so I was ...
0
votes
0answers
649 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
0answers
237 views
Connect Date Filter Web Part to a List
I am currently trying to connect a Date Filter Web Part to a list, where the date filter will be filtering based on the list items Created feild. It connectes but the disconnects.
Below are the steps ...
