Performing Joins Between Sharepoint Lists

Yes you can! Thank you Sahil Malik!

Today - Created, or Today - Modified

Yes, it is that simple. In a sharepoint calculated column, AFTER you perform the [Today] Sharepoint trick - you can use Today - Created, or Today - Modified in a calculated column to display X days old. Don't forget to format the column as numeric with no decimal places as we are reminded here.

Employee Training Scheduling and Materials

I've been working a lot with the Employee Training Scheduling and Materials application template for Sharepoint and wouldn't have found my way through without the help of the the Microsoft SharePoint Designer Team Blog:

• Training Site Template: Part 1: Introduction
• Training Site Template: Part 2: Workflows
• Training Site Template: Part 3: Custom Views and Forms

Sharepoint Export Event

You may want to customize the Export Event in DispForm.aspx or you may want to include Export Event as a link in a Sharepoint workflow.

Using the directions posted here: http://weblogs.asp.net/wkriebel/archive/2004/04/02/106767.aspx

I created a link in a sharepoint workflow email with mostly hard coded values of the site and the GUID of the list - but used a dynamic list item ID value using "Add Lookup to Body"

Here is an example working url to use to export a sharepoint event:

./Sites/mySiteWithEvents/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List={9aa84cdc-1179-4da1-ba1a-f7a579955066}&CacheControl=1&ID=97&Using=event.ics