MOSS How To: Change Calendar Item appearance

Hey guys,

today i will show you how you can modify the calendar view to display e.g. start and end time of an event.

The default style is this:

 

To display also the end time of an event or meeting you have to create at first a new column of type calculated (calculation based on other columns). 

Enter a name e.g. Item Titel, as data type of the calculation choose date & time.

And here is the formula which you can enter:

=Title&" , "&TEXT([Start Time];"hh:mm")&" - "&TEXT([End Time];"hh:mm")

After you have sucessfully created this column you have to modify the Calendar View.

So go back to the Calendar and click modify this view. You will see an area called 'Calendar Columns', there you can specify which column should be shown

to the user in the Views Month, Week and Day. Here you have to choose your newly created Column, in my case 'Item Title'.

Click Ok and have a look at the result:

 

 

The Calculated Column has more advantages as some of think, I will write more about the formulas and constants that can be used by this column type in further posts.

 

cheers Big Smile

 

 


Posted Mar 17 2009, 11:14 AM by Nadine Storandt
Filed under: ,

Comments

hero_turtle wrote re: MOSS How To: Change Calendar Item appearance
on 04-02-2009 16:24

Great post, thanks it helped a lot.

Is there anyway to add more information on the calendar view? as I would also like the creater to show up.

Cheers

Nadine Storandt wrote re: MOSS How To: Change Calendar Item appearance
on 04-04-2009 14:27

Hey,

yes of course every column could be added to the calculated field. Try it out here is a link to a official MS Page where the most formulas and options are described.

office.microsoft.com/.../HA011609471033.aspx

Jason wrote re: MOSS How To: Change Calendar Item appearance
on 04-30-2009 3:21

The problem is you have just added duplicate information. What needs to be done is add the end time to the date above the linked title.

Nadine Storandt wrote re: MOSS How To: Change Calendar Item appearance
on 04-30-2009 9:38

Yes i know jason :) But it should only be an example ;)

Pratik wrote re: MOSS How To: Change Calendar Item appearance
on 03-23-2011 14:51

Thanks Nadine,

This is working for me.

This is a good OOTB workaround.

developers.de is a .Net Community Blog powered by daenet GmbH.