Skip to main content

Using XPath to display only the current Year

Using XPath to display only the current Year
1. Right click your textbox and select properties.
2. For Data Types select Text (string).
3. Select the formula button next to the Value box in the Default Value section .
4. Select Insert Function.
5. Select substring-before (in the Text functions).
6. For the first field, put in the field with the date your want or the function today() for today's date.
7. After the comma, put in "-"
8. Your final formula should look like this: substring-before(today(), "-")

The substring-before function takes all the characters in the first string (today() in our case) up to the first occurrence of the character in the second string (the hyphen, for us). Since today() returns a date formatted as: "2008-07-16", taking everything before the first hyphen returns the year.

Popular posts from this blog

Custom Error Page in SharePoint 2010

You can easily dispaly your own HTTP 404 Page Not found Error page for each of your SharePoint Web Application. A custom Error page can be associated with each Web Application in SharePoint and you can redirect the 404 error page to your own specified error page. SharePoint has it's error Pages stored at this location: 14\TEMPLATE\LAYOUTS\1033\ERRORV4.html 14\TEMPLATE\LAYOUTS\1033\sps404.html The one we need is the sps404.html. If you open this page you will see: STSNavigate("/_layouts/spsredirect.aspx?oldurl="+ requestedurl); Here spsredirect.aspx is the Error page currently used by sharepoint. So what we need to do is, first make a copy of the sps404.html, rename it - in my case mscom404.html and save it at the same location (14\TEMPLATE\LAYOUTS\1033).Now in the STSNavigate replace spsredirect.aspx with your own aspx page. The url in STSNavigate should be a properly working url, then only the redirection will work. as you can see in the code above, i'm placing my e...
Read more

Content Types not visible in SharePoint2010

while working in VS2010 and creating SharePoint Content Types using CAML, i came accross an interesting issue. the issue was that when creating a content type, it was not showing up in the Site content Types page. Then after struggling a lot and almost exploring all the properties available, i found that there is a property called "Overwrite" and setting it's value to "True" i.e. Overwrite=True, makes the content type available in the Site Content Types Page.
Read more

Invalid Associated Content Type

Many of you who are playing with SharePoint might have seen this error message before (:) ..."Invalid Associated Content Type". while working on one my Sharepoint Projects , i came accross this error of Invalid Associated Content Type, i first verified the Content Type that was associated with the Page layout and found everything was fine except one. The mistake i was doing was, not adding the following to within the Page Layout Content Type As soon i add the Content Type in , proper content Type's name apppears in place of (Invalid Associated Content Type).
Read more