in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

This Blog

Syndication

News

Interested in consulting work or becoming a consultant? Contact Me.

- Quick Links -


- Blog Bits -
 My Professional Profile




Subscribe in NewsGator Online
Add to My MSN
Add to Google

Subscribe with Bloglines





Tags:

Translate Text or URLs
Who links to my website?

The Boiler Room - Mark Kruger (5 Year Microsoft SharePoint MVP)

Published by

Comments

 

Ishai Sagi [MVP] said:

Archiving purposes?

Mark, please let me know why you feel this duplication is needed?

June 21, 2007 8:28 PM
 

Tobias Zimmergren said:

You can add www.sharepointblogs.com/zimmer to the list!

Cheers

June 26, 2007 11:40 AM
 

kcornwell said:

80% SharePoint content.

www.kevincornwell.com/blog

June 26, 2007 12:21 PM
 

John Stover said:

June 26, 2007 1:51 PM
 

Colección de recursos SharePoint « Jorge Dieguez Blog said:

Pingback from  Colección de recursos SharePoint « Jorge Dieguez Blog

June 26, 2007 3:16 PM
 

Jorge Dieguez Blog said:

Una gran colección de recursos de SharePoint. WebParts, Artículos, Guías, Herramientas. Mark Kruger lo

June 26, 2007 3:18 PM
 

Blog de Jorge Dieguez said:

Una gran colección de recursos de SharePoint. WebParts, Artículos, Guías, Herramientas. Mark Kruger lo

June 26, 2007 3:21 PM
 

Todd Friedlich said:

Check out Eric Stallworth's

www.theartofsharepoint.com

June 26, 2007 3:41 PM
 

Chandima said:

June 26, 2007 4:30 PM
 

Links (6/26/2007) « Steve’s SharePoint Stuff said:

Pingback from  Links (6/26/2007) « Steve’s SharePoint Stuff

June 26, 2007 8:59 PM
 

Links (6/26/2007) « Steve’s SharePoint Stuff said:

Pingback from  Links (6/26/2007) « Steve’s SharePoint Stuff

June 26, 2007 8:59 PM
 

Links (6/26/2007) « Steve’s SharePoint Stuff said:

Pingback from  Links (6/26/2007) « Steve’s SharePoint Stuff

June 26, 2007 8:59 PM
 

Links (6/26/2007) « Steve’s SharePoint Stuff said:

Pingback from  Links (6/26/2007) « Steve’s SharePoint Stuff

June 26, 2007 8:59 PM
 

Itay Shakury said:

June 27, 2007 3:57 AM
 

Spence said:

blogging at www.harbar.net

June 27, 2007 6:31 AM
 

SharePointKicks.com said:

You've been kicked (a good thing) - Trackback from SharePointKicks.com

June 27, 2007 7:57 AM
 

Kaizenlog ?? Microsoft 27/06/2007 said:

Pingback from  Kaizenlog ?? Microsoft 27/06/2007

June 27, 2007 12:44 PM
 

SharePointBuzz.com said:

How about SharePoint Buzz?

June 27, 2007 1:19 PM
 

Andrew Woodward said:

Please add  Andrew Woodwards (my blog)

and the Point is?

http://www.21apps.com

June 27, 2007 3:27 PM
 

Erica Toelle said:

Please add Kristian Rickard (MSFT):blogs.msdn.com/.../default.aspx

Thanks for the OPML!

June 27, 2007 5:22 PM
 

Sharepoint link love 06-28-2007 at Virtual Generations said:

Pingback from  Sharepoint link love 06-28-2007 at  Virtual Generations

June 28, 2007 1:54 AM
 

Sharepoint link love 06-28-2007 at Virtual Generations said:

Pingback from  Sharepoint link love 06-28-2007 at  Virtual Generations

June 28, 2007 1:58 AM
 

Chris White said:

Please add my blog to the list:

chrissyblanco.blogspot.com

Thanks.

June 28, 2007 4:34 AM
 

John Wilson said:

Please add Steve's blog

stevepietrekweblog.wordpress.com

June 28, 2007 10:45 AM
 

Ricky Spears said:

Don't forget the SharePoint Solutions blog:

sharepointsolutions.blogspot.com

June 28, 2007 3:42 PM
 

Pedro Serrano said:

Here's mine:

pserrano.blogscavedigital.com

SharePointing 'till you drop ;)

Cheers,

Pedro

June 28, 2007 5:49 PM
 

John said:

Thank you for the nice post.

June 29, 2007 8:44 AM
 

Brent said:

June 29, 2007 10:03 PM
 

Mike Walsh's WSS and more said:

July 1, 2007 1:37 AM
 

Mike Walsh's WSS and more said:

July 1, 2007 1:37 AM
 

Dattard said:

Putting images instead of status images (e.g. Red / Amber / Green, or Priority 1 / 2 / 3 Images) in the Dataview.

July 6, 2007 4:12 AM
 

jfriend80 said:

Mark:

I read the blurb in this entry about how "... the formula will not calculate all list items on refresh but rather by the addition and deletion of a new “Today” column or by editing each of the list items individually.  However, you can code this to make it more dynamic..."  

Can you help w/ this code?  

July 6, 2007 5:23 PM
 

mansour fallah ghanbari said:

thank you

this is great

July 8, 2007 8:16 AM
 

Blog del CIIN said:

Siguiendo con la serie de post sobre recursos de WSS 3.0 & MOSS que iniciamos con las entregas I

July 9, 2007 2:39 PM
 

Kyle said:

Great tips :)  The one that confounds me though, is how do I display data that is of type User or Group?  It appears as a html snippet with all the quotes escaped :(

July 11, 2007 7:36 PM
 

Daniel McPherson said:

Hey Mark,

I've moved my blog (wanted it to be MOSS based), and left Microsoft. Be great to have you drop by.

www.point2share.com/blog

Daniel

July 13, 2007 4:14 AM
 

Marja said:

Great tips! Really usefull!

What still is bugging me at the moment is that when you use a multiple lookup column you loose the individual links... Any tip for this?

July 15, 2007 5:56 PM
 

Vadim said:

It works, but next day (or month) you see that nothing has changed in your lists. It seems that Sharepoint remembers current value of [Today] at the moment you create (and delete) columns, and your filters stay the same. If you repeat the procedure next day, it will be OK again.

Any ideas/comments?

July 17, 2007 11:42 PM
 

Cory Burns said:

July 18, 2007 5:25 AM
 

Kevin Hoffman said:

July 20, 2007 6:39 AM
 

Ike said:

July 22, 2007 2:50 PM
 

Tom said:

re: jfriend80 post

I second his post.  I'm using the technique you outline to generate an 'aging' summary report and as a work around am having to add and delete the  [Today] column each day.

Would really appreciate some more insight on how to make this more dynamic and hopefully avoid this small, but manual, daily work around.

July 23, 2007 6:00 PM
 

Blog del CIIN said:

Siguiendo con la recopilación periódica de recursos sobre WSS 3.0 & MOSS, esta semana en el número

July 24, 2007 7:12 AM
 

Blog del CIIN said:

Siguiendo con la recopilación periódica de recursos sobre WSS 3.0 & MOSS, esta semana en el número

July 24, 2007 7:12 AM
 

mkruger said:

jfriend80/Tom,

Talk to your devs about creating a simple application to add and remove the field on the list daily.  They can access the Object Model to get the list and list fields, delete the field, and then recreate it.  That should do the trick for you.

-Mark

July 24, 2007 9:12 AM
 

Riccardo Gozzi said:

Hey there. Thanks for the Tips.

Do you have any experiance with using external XSLT files and linking to them either using the <xsllink> or <xsl:import methods. Im having problems when saving pages with dataview webparts setup like this. Causes Designer to crash after the 3 or so save.

Was wondering if you knew of any other methods or had any tips?

July 25, 2007 6:53 AM
 

Ange said:

I have the same problem -- I need the list to automatically reflect the current month, not the month that was stored in the field [Today]

July 25, 2007 11:56 AM
 

Jen Refsnider said:

Great tips!  Thanks for sharing -- saved me lots of frustration on date comparisions!!

July 27, 2007 12:10 PM
 

Chris O'Brien said:

Focus on WCM and deployment (Solutions, Features etc.) over at sharepointnutsandbolts.blogspot.com

August 3, 2007 4:40 AM
 

JohnRew said:

Such a great collection of resources, tips and tools! Thanks and much appreciated! Maybe you've forgotten some tools. For example, I would also add to this list a new tool from scriptlogic for managing SharePoint permissions - <a href="www.scriptlogic.com/.../">security explorer for Sharepoint</a>. I've been using the beta version since TechEd and now it's finally been released. What I like in this tool that it simplifies the process of assigning and managing SharePoint permissions, permissions groups and levels using an easy interface.

August 7, 2007 9:08 AM
 

Seth said:

Brilliant!  I have been looking all morning for some examples of formula syntax for a calculated column in SharePoint 2007 and after much angst finally found this post.  Exactly what I needed.  Thank you sir.

Seth

August 9, 2007 4:01 PM
 

Atholl said:

Thanks for a great list

August 14, 2007 3:39 AM
 

MindBusiness Blog » Verwenden von [Heute] in berechneten Spalten said:

Pingback from  MindBusiness Blog &raquo; Verwenden von [Heute] in berechneten Spalten

August 15, 2007 11:55 PM
 

Ryan McIntyre said:

Scenario: A list contains items which have a recurring date. Anniversary, birthday, things like that.

August 17, 2007 4:33 PM
 

Zlatan said:

Hi, you can add Zlatan's Blog.

http://dotnet.org.za/zlatan/

August 19, 2007 12:15 PM
 

Ulrich Bernskov said:

Good list of relevant links.

Thanks

August 23, 2007 3:55 AM
 

Mohiuddin Qadri said:

What about current time? Today is returning today's month date and year. It doesn't return current time.

How is it possible to calculate based on current time??

September 4, 2007 3:32 AM
 

Matthew said:

Great collection! Thx!!

September 4, 2007 2:40 PM
 

Joel said:

Argh! I swear something similar this worked in SharePoint 2003 (like joelsef.blogspot.com/.../recently-updated-documents-in.html). But this birthday trick doesn't work month-to-month--when the month changes over the calculated column still keeps the [Today] value of the month when the calculated column was created.

September 5, 2007 10:07 AM
 

Michael Lotter's little view of the big world of SharePoint and InfoPath said:

Recently I was asked to create new Monthly and Quarterly DVWPs for the &quot;Time Card Management&quot;

September 6, 2007 3:41 PM
 

Blogger Loser » Blog Archive » Example of MOSS calculation fields for Month-Year and Quarter-Year from date column said:

Pingback from  Blogger Loser  &raquo; Blog Archive   &raquo; Example of MOSS calculation fields for Month-Year and Quarter-Year from date column

September 6, 2007 5:12 PM
 

texas state teachers association mission statement said:

texas state teachers association mission statement

September 8, 2007 9:13 PM
 

kane county teachers credit union aurora il said:

kane county teachers credit union aurora il

September 9, 2007 11:23 AM
 

the open university of israel said:

the open university of israel

September 9, 2007 11:46 PM
 

16 Links Today (2007-09-10) said:

Pingback from  16 Links Today (2007-09-10)

September 10, 2007 10:20 AM
 

16 Links Today (2007-09-10) said:

Pingback from  16 Links Today (2007-09-10)

September 10, 2007 10:20 AM
 

16 Links Today (2007-09-10) said:

Pingback from  16 Links Today (2007-09-10)

September 10, 2007 10:21 AM
 

dataview tips &#038; free webparts « Free, SharePoint, Party, Parts, DataView, Tips, konfabulieren « konfabulieren said:

Pingback from  dataview tips &amp;#038; free webparts &laquo; Free, SharePoint, Party, Parts, DataView, Tips, konfabulieren &laquo; konfabulieren

September 14, 2007 2:31 AM
 

dataview tips &#038; free webparts « Free, SharePoint, Party, Parts, DataView, Tips, konfabulieren « konfabulieren said:

Pingback from  dataview tips &amp;#038; free webparts &laquo; Free, SharePoint, Party, Parts, DataView, Tips, konfabulieren &laquo; konfabulieren

September 14, 2007 2:31 AM
 

myspace music video codes for free said:

myspace music video codes for free

September 16, 2007 5:12 PM
 

Patrick.O.Ige said:

Ways of showing lists in Multiple sites and subsites

September 25, 2007 1:50 AM
 

Mirrored Blogs said:

Here is the OPML file that contains a list of active SharePoint bloggers. Updated on 08/30/2007.Feel

October 1, 2007 7:06 AM
 

Terry Talley said:

Some more insight on using the Object Model to perform the auto [Today] creation and deletion would be helpful.  I, personally, would like to know just how that is done.  It would be extremely helpful....

October 3, 2007 1:58 AM
 

ScottM said:

I'm trying to implement Tip #5 and I'm getting an error:

"Error: The charecter '<' cannot be used in an attribute value. <img border...."

Am I just trying to put the code in the wrong place?

Thanks,

Scott

October 3, 2007 11:24 AM
 

Mark Kruger said:

ScottM,

Try to copy and paste into notepad and remove any linebreaks.  XSLT will complain if it doesnt copy/paste correctly.  

Mark

October 3, 2007 4:11 PM
 

ScottM said:

Thanks for the reply Mark.  I got that working!

October 5, 2007 4:07 PM
 

Murugesank said:

Unable to use Sharepoint 2003 query tool as it does not search the requested criteria, also it is not accepting the folder under the url. (eg: https://domain/folder/) need assistance.

Please assist

October 11, 2007 6:04 AM
 

Amit said:

Thanks for the post.

Do you have any idea how to display the Month Name like January, February etc. using Calculated Column in SharePoint 2007?

October 18, 2007 6:22 PM
 

Aidan Garnish said:

ther MOSS link...loads of resources!

October 20, 2007 3:55 PM
 

manihari said:

hi,

this was an excellent blog.

I've some task similar to this.

About my task:

Its about Issue Tracker, in which Due Date should be automatically generated based on the Priority(LOW-MEDIUM-HIGH) givent by the respective person.

I'm little bit confused in doing this task.

Please help me in doing this task.

And also I faced a problem regarding the maximum length of Characters the Calculated Value field takes.

I faced a restriction problem in the Calculated value field

Thankyou all in Advance.

October 23, 2007 5:05 AM
 

Michael Blumenthal said:

I'm blogging about SharePoint too:

http://blumenthalit.net

October 29, 2007 3:41 PM
 

Tim Staddon said:

The tip's worked for me but my web part won't let me filter against anything other than currentuser or currentdate - pointless considering I need to filter by week!

If anyone knows a way around that I'd be well impressed.

As for displaying the month name, try formatting your date field with a formula - eg

<xsl:value-of select="substring-before(ddwrt:FormatDate(string($fieldvalue) ,1033 ,3),',')" />

October 31, 2007 7:50 AM
 

Murky said:

This trick doesn't seem to work for the same reasons others mention here. I wanted to use "today' in an if statement, but it wasn't working so I changed the calculated field to simply display today's date "=today". When I first created the field it displayed today's date. But the next day when I looked at the field it was still displaying yesterday's date instead of changing to today's date. That makes this trick useless. Am I doing something wrong?

November 1, 2007 3:40 PM
 

Seajoker said:

I have a recurring task that is set for the first day of the month.  How can I apply a calculation on a recurring date?  I want to add or subtracts days based on the recurring date.  My current problem is the recurring date calculation, calculates based on the first day of the entry and not the next month's date.  Any work around?

November 7, 2007 1:54 PM
 

Smith Data Processing Services » Blog Archive » links for 2007-11-08 said:

Pingback from  Smith Data Processing Services  &raquo; Blog Archive   &raquo; links for 2007-11-08

November 7, 2007 11:21 PM
 

audrie said:

When you drop a Thumbnail or LargeThumbnail column from a slide library into a data view the image itself does not show up unless you use a single or multi line FORM.  Is there a way it get the picture to show up in a Multiple Line View that is not a Form or in Edit mode?

November 8, 2007 1:27 AM
 

home » Free SharePoint Web Parts said:

Pingback from  home &raquo; Free SharePoint Web Parts

November 9, 2007 11:09 PM