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

re: Using [Today] in a Calculated Formula (Birthday Lists)

Shai — Thu, 03 Jul 2008 14:38:03 GMT

Genius.

Posted on SharePoint Blogs

re: HowTo: Using SharePoint Calculated Columns to Display a List Item as "X" Days Old

gokhan — Tue, 24 Jun 2008 14:52:16 GMT

=CONCATENATE(ABS(HOUR(today())-HOUR(today()));":";ABS(MINUTE(Modified)-MINUTE(Created)))

this works

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Nimi Kaul — Tue, 17 Jun 2008 11:47:16 GMT

THanks. THis was very helpful.

But, will i have to create the today column every month (everytime a month changes)?

Posted on SharePoint Blogs

re: Content Query Web Part - Unable to Activate the Publishing Infrastructure

Paul — Wed, 11 Jun 2008 19:45:36 GMT

TJ,

Make sure you have MOSS installed (not just WSS, there is no publishing in WSS).

Then make sure the SharePoint publishing Infrastructure is turned on at the Site Collection Feature level, then turn on the Publishing feature in the 'Site Features' section.

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Motorboy — Wed, 11 Jun 2008 07:38:19 GMT

I have created similar issue as Michelle.

Two collumns:

DayToday: =DAY(BirthDate)-DAY(Today)

ThisMonth: =MONTH(BirthDate)-MONTH(Today)

where I setted up filter on DayToday=0 and ThisMonth=0, but I found out, that this columns doesn'n re-count automatically :-(

Any Ideas?

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Steven — Tue, 10 Jun 2008 14:31:09 GMT

Excellent find!! Why wouldn't Microsoft include the [Today] functionality as built-in?!?

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Michelle — Mon, 09 Jun 2008 19:07:00 GMT

I am using this to determine someone's age based on subtracting the year in the birthday field from the year in the today field. This works fine, but i want it to display "n/a" in the age column if the birthday field is null. Does someone know how to do this? Here is my current formula for age:

=(YEAR(today))-(YEAR([Child 1 Birthday]))

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Kathy — Fri, 06 Jun 2008 14:01:37 GMT

Has anyone figured out how to use the TODAY as the current date and time so that items that are tracked for aging are updated?

Posted on SharePoint Blogs

re: HowTo: Using SharePoint Calculated Columns to Display a List Item as "X" Days Old

Alvin — Thu, 05 Jun 2008 01:13:11 GMT

This post really help me a lot, but is there possible for us to calculate the time, i mean in hour, not only in year, month and date. thanks

Posted on SharePoint Blogs

re: Free SharePoint DataView Tips

KellUD1 — Wed, 04 Jun 2008 19:52:25 GMT

Concerning tip number 6, you describe how to get around the data view returning ID;#Text for lookup columns. Is this just true in Front Page? I'm working with SharePoint Designer and I want my data view to return lookup columns in this format, but I can't figure out if its possible. Any Suggestions?

Posted on SharePoint Blogs

new web parts sharepoint 2007

new web parts sharepoint 2007 — Tue, 03 Jun 2008 10:26:16 GMT

Pingback from new web parts sharepoint 2007

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Motorboy — Mon, 02 Jun 2008 06:30:27 GMT

Yes, I have already tried what Dan wrote's, but no progress:-( -> "Syntax Error"...

Simplier formulas like "=DAY(DOB)" or "=MONTH(DOB)" are OK?!

Haven't I vergot set up any settings in CA or in SSP?

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Gristy — Sun, 01 Jun 2008 00:17:15 GMT

well tried what Dan said exactly, and the month didnt change now its june. oh well

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Gristy — Sun, 01 Jun 2008 00:17:13 GMT

well tried what Dan said exactly, and the month didnt change now its june. oh well

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Motorboy — Sat, 31 May 2008 14:14:14 GMT

Hi,

I have any problems with there used calculated formulas. When I tried to create this calculated columns ("MonthCheck" and "MonthCheck is equal to Birthday") it retrieved me this error:

The formula contains a syntax error or is not supported. at Microsoft.SharePoint.Library.SPRequestInternalClass.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd)

at Microsoft.SharePoint.Library.SPRequest.AddField(String bstrUrl, String bstrListName, String bstrSchemaXml, Int32 grfAdd)

I don't know why? Any Ideas?

Thanks

Posted on SharePoint Blogs

re: Free SharePoint DataView Tips

Niv Hess — Wed, 28 May 2008 09:38:35 GMT

Trying to work with tip 2, I find that Sharepoint designer brings all items even though my defualt view has a filter less then [Today]+30. Any suggestion?

Posted on SharePoint Blogs

re: Free SharePoint DataView Tips

Niv Hess — Wed, 28 May 2008 09:38:35 GMT

Trying to work with tip 2, I find that Sharepoint designer brings all items even though my defualt view has a filter less then [Today]+30. Any suggestion?

Posted on SharePoint Blogs

re: Content Query Web Part - Unable to Activate the Publishing Infrastructure

TJ — Mon, 26 May 2008 13:17:16 GMT

Hi,

I am having problems trying to enable the 'Office SharePoint Server Publishing' feature . I am added as a site collection administrator. However when I go to the site settings -> site collection features I only see 2 options which are enabled. These are

1) Fields and Content Types for the Windows SharePoint Services Application Templates

2) Three-state workflow

I do not see any of the site collection features like you have printed above.

Also I have noticed that I do not have a AreaNavigationSettings.aspx in the _layouts folder

http://<your site url>/_layouts/AreaNavigationSettings.aspx

Any I doing something wrong here? Any I leaving anything out?

Any help would be greatly appreciated.

Posted on SharePoint Blogs

re: Free SharePoint Web Parts (3rd Party)

neeraj — Fri, 23 May 2008 12:33:56 GMT

HI ,

i need to made the new webpart such that it will extend the Business data Item (BDI)

but i did not find the base class for BDI , to which i will extend to my webpart

something like

class a :BDIClass

{

}

from where i will g

et BDIClass

I need to do this so that i can make the web part same as BDI with some extra feature but needs all the property of BDI like xml editor ,caching etc

is their any other approach or i am in wrong track

some where i have also read that property can be inherited by GUID's of BDI

Thanks,

Neeraj

Posted on SharePoint Blogs

re: Using [Today] in a Calculated Formula (Birthday Lists)

Gristy — Thu, 22 May 2008 03:17:06 GMT

thanks dan gonna set this up now and find out if it works june 1st :)

Posted on SharePoint Blogs

super bowl xl commercials

super bowl xl commercials — Mon, 19 May 2008 00:52:02 GMT

Pingback from super bowl xl commercials

Posted on SharePoint Blogs

re: The SharePoint Community - SharePoint Blogs!

Joel Oleson — Sat, 17 May 2008 05:35:26 GMT

Can you add my new one http://www.sharepointjoel.com? I think the other one is still a good resource.

Joel

Posted on SharePoint Blogs

re: Free SharePoint DataView Tips

Collin Ames — Fri, 16 May 2008 15:00:14 GMT

What's the easiest way to do conditional filtering? For example, I have a glossary list that I'd like to be able to filter by a paramter in the query string called "Letter". Simply adding a filter to have Title Begins With Letter doesn't work if you provide either a blank letter parameter or no parameter at all; in that scenario, I want it to display all of the times (i.e., don't apply the filter when there is no parameter value).

Any thoughts on this?

Posted on SharePoint Blogs

re: 2007 MOSS Resource Links (Microsoft Office SharePoint Server)

sjs — Fri, 16 May 2008 04:46:36 GMT

excellent but no thing about seach service

Posted on SharePoint Blogs

boiler partws

boiler partws — Thu, 15 May 2008 15:20:49 GMT

Pingback from boiler partws

Posted on SharePoint Blogs