.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Find week number in xpath from two dates in SharePoint 2010

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


I am trying to determine the week of the year from two dates. The first date will be the first day and month of that year (e.g. 01/01/2005) and the second will be the date of a document(05/05/2005). We tried to accomplish this same task within SharePoint, not using the SP Designer, however, we could not because we could not utilize the name column. Anyhow below is what I got so far. I search for a date function to perform subtraction but could not find any. Thank in advance.


ddwrt:FormatDate(substring($thisNode/@FileLeafRef.Name,1,10),1041,1) -ddwrt:FormatDate(concat(substring($thisNode/@FileLeafRef.Name,1,4),'-01-01'),1041,1)

View Complete Post

More Related Resource Links

Sharepoint 2010 can't find People. How to solve it?

I have following problem: when i try to search people in any site i have to write whole "Last Name". That's mean, when i write, only part of "Last Name" i get no results. Why it happens? How i can to solve the problem?   Thanks.

Visual Studio 2010 can't find the Sharepoint Foundation 2010 Server when compiliing, Standalone vs

I'm wondering if we installed Visual Studio correctly cos when we get into Visual Studio 2010 the "Deploy as a Farm Solution" is the only available button option and the "Deploy as a Sandbox Solution" is un-selectable, grayed out, assuming the "Sandbox" solution is the "Standalone" approach? So when we go to compile a Workflow, the error message says the Sharepoint Server is not found" Could this "Deploy as Farm Solution" be a problem when we were instructed to install Sharepoint 2010 Foundation as a "Standalone" install? in other words we're trying to find out why when we go to compile a Workflow in Visual Studio 2010 that it can't find the Sharepoint Server Step 3: Install SharePoint 2010 1.  To install SharePoint Server 2010 or SharePoint Foundation 2010, open a Command Prompt window, and then type the following at the command prompt: On the Choose the installation you want page, click Standalone to install everything on one developer workstation. Thanks very much for any suggestions, ideas or pointers! BobK

find number of sundays between two dates using sql

can i find total number of sundays between two dates using sql? or total number of days between two days except sundays

format-number issues with the Data View Web Part in SharePoint 2010

I have a number column named @Year_x0020_1_x0020_Revenue in the data view web part in SharePoint Designer 2010. In the Xpath expression builder - @Year_x0020_1_x0020_Revenue previews "500,000" If I use the format-number in the Xpath expression builder ==> format-number(@Year_x0020_1_x0020_Revenue, '$#,##0.00;-$#,##0.00'), it returns NaN. Is there any reason? 

where do find complete guide for sharepoint 2010 server object model?

where do find complete guide for sharepoint 2010 server object model?

Maximum number of items in a SharePoint 2010 list

Hi, Is there a recommended maximum number of items that can go into a SharePoint 2010 list? I seem to recall that earlier versions seemed to have performance problems with more than 2000 items. I have a table that has some 50,000 records and would love to convert it into a list.   Thanks John JohnSpilker

Currency and number column error with office 2007 document formats in SharePoint 2010 library

Hi there,



The following error occurred within a SharePoint 2010 document library:

As I tried to test out the new SharePoint 2010 environment I changed the metadata from a few documents within a document library. I noticed that the data from the currency und number field was incorrect from a few documents. The numbers looked like that the decimal separator were ignored. For an example: 123.456,78 was saved as 12.345.678.

At first I thought it could be a language incompabilty but if that would be the case: Why would there be other documents which show the correct number?


I created another document library to recreate this error. And there I noticed the real reason: Every time I changed these fields from a document which was saved in the office 2007 format the error occurred. The metadata from the documents in the office 2003 format were correct.


Has anyone a similar problem or got an idea how to solve this problem?


System Specs:

Frontend: Windows Server 2008 SP2 ent

where can i find Jquery tabs webparts for Sharepoint 2010?


Hi All, I'm after a Jquery tabs webparts for Sharepoint 2010? i came across this one http://jquerytabswebpart.codeplex.com/ But its only for SP 2007. Any resources would be appreciated. THanks

How to add a auto genterated column in a sharepoint list of type number in SharePoint 2010


am try to generate a auto increment column for my SharePoint list of type number type?

=TEXT(1000+ID,0) , when i use this formula it works some time and some time it doesn`t increment?


do you know any out of box way to do this?

Thanks in Advance

Share Knowledge and Spread Love!

How to find number of documents uploaded to each sharepoint site?


How can I determine how many documents are uploaded to each sharepoint site?

Short Overview of SharePoint Features in Visual Studio 2010

As you probably know, Visual Studio 2010 was announced earlier this week and it contains a lot of cool features and project templates for SharePoint developers. Below is a short overview for some of the SharePoint development related features and project templates.

How to get more information about the exceptions that can happen in SharePoint 2010 projects?

In case there is an exception anywhere in the SharePoint 2010 project (most common place an exception would happen is during deployment of your SharePoint project, custom deployment configuration or custom deployment steps), there's a registry key EnableDiagnostics available for you to use.

InfoPath 2010 cannot connect to SharePoint 2010

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

Installing and configuring SharePoint 2010

The following steps show how to install SharePoint 2010 on VMware workstation 7.0. Host computer used during the preparation of this walk-through was a Vista (32-bit) machine and guest machine used was VMware workstation 7.0 with Windows Server 2008 Service Pack 2 (64-bit).

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Developing on SharePoint 2010 Intro Tutorial

Folks, this is a exciting news for SharePoint Geeks that the availability of Developing on SharePoint 2010 Tutorial can be access here.

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend