Optional Content

You can configure the following optional content:

 

Table 3. Optional Content

Element	Description
Recurrence Field Name	Allows you to enter the name of the field in the SharePoint list that contains the recurrence data. This property is optional. The default value is RecurrenceData, the name of the field for the SharePoint calendar list that contains the recurrence data. If the calendar displays data from another type of list, leave the value of the properly blank. Only the event list can have recurrence data (SharePoint does not allow you to add a new field to the list with Recurrence type).
Display Field Name	Allows you to enter the name of the field in the SharePoint list that contains the title for the item. The default value is Title, which is the name of the field for the SharePoint event list that contains the event title. If the calendar displays data from another type of list, you may have to adjust the value of this property. For example, if you want to display data from the Projects list, you may use Project Name for the value of this property. If you want to display the information from more than one fields, then specify the format in the Display Format property.
Display Format	Allows you to enter the format of the title. You can use the <%FieldName%> field replacement expression to refer to a certain field. The FieldName is case sensitive. This property takes precedence over the Display Field Name property. NOTE: For more information, see Display Format
Tooltip Field Name	Allows you to enter the name of the field in the SharePoint list that contains the description for the item. The description for the item is displayed as a tooltip when you hover your mouse over an item in the calendar. The default value is Description, which is the name of the field for the SharePoint event list that contains the event description. If the calendar displays data from another type of list, you may have to adjust the value of this property. For example, if you want to display data from the Tasks list, you may use Task Description for the value of this property. If you want to display the information from more than one field, specify the format in the Tooltip Format property.
Tooltip Format	Allows you to enter the format of the tooltip. You can use the <%FieldName%> field replacement expression to refer to a certain field. The FieldName is case sensitive. This property takes precedence over the Tooltip Field Name property.

Display Format

This attribute specifies how the field value is formatted when displayed.

The syntax for the Display Format string is as follow: {0:FormatString}. The following are the value of the Display Format attribute grouped by the type of the value to be formatted.

 

Table 4. Basic Number Formatting

Format	Type	Output (if input is double value 2.34)	Output (if input is integer value 12400)
{0:c}	Currency	$2.34	$12,400
{0:d}	Decimal (whole number)	N/A	12400
{0:e}	Scientific	2.340000e+000	1.240000e+004
{0:n}	Number with commas for thousands	2.34	12,400
{0:x}	Hexadecimal	N/A	cf90

 

Table 5. Custom Number Formatting

Specifier	Note	Example	Output (if input is 12400.25)
0	Zero placeholder	{0:00.00}	12400.250
#	Digit placeholder	{0:##.####}	12400.25
.	Decimal point	{0:0.0}	12400.3
,	Thousands separator	{0:0,0}	12,400
%	Percent (Multiplies by 100 and add % sign)	{0:0%}	1240025%

For custom number formatting, you can combine different specifiers. For example: {0:0,0%} will output 1,240,025%.

 

Table 6. Date Formatting

Format	Type	Output (if input is November 14, 2007 10:34:23 PM)
{0:d}	Short date	11/14/2007
{0:D}	Long date	November 14, 2007
{0:t}	Short time	10:34 PM
{0:T}	Long time	10:34:23 PM
{0:f}	Full date and time	November 14, 2007 10:34 PM
{0:F}	Full date and time (long)	November 14, 2007 10:34:23 PM
{0:g}	Default date and time	11/14/2007 10:34 PM
{0:G}	Default date and time (long)	11/14/2007 10:34:23 PM
{0:M}	Month and day	November 14
{0:r}	RFC1123 date string	Wed, 14Nov2007 10:24:23 GMT
{0:s}	Sortable date string	2007-14-11T22:34:23
{0:u}	Universal sortable, local time	2007-14-11 22:34:23 PM
{0:U}	Universal GMT	November 14, 2007 10:34:23 PM
{0:Y}	Month and year	November, 2007

 

Table 7. Custom Date Formatting

Specifier	Note	Example	Output (if input is November 14, 2007 10:34:23 PM)
dd	Day	{0:00.0}	14
ddd	Day name	{0:##.####}	Wed
ddd	Full day name	{0:0.0}	Wednesday
f,ff,...	Second fraction	{0:fff}	230
gg	Era	{0:gg}	A.D.
hh	2 digit hour	{0:hh}	10
HH	2 digit hour in 24 hour format	{0:HH}	22
mm	Minute 00-59	{0:mm}	34
MM	Month 01-12	{0:MM}	11
MMM	Month abbreviation	{0:MMM}	Nov
MMMM	Full month name	{0:MMMM}	November
ss	Seconds 00-59	{0:ss}	23
tt	AM or PM	{0:tt}	PM
yy	Year, 2 digits	{0:yy}	07
yyyy	Year	{0:yyyy}	2007
zz	Timezone offsets, 2 digits	{0:zz}	-05
zzz	Full timezone offsets	{0:zzz}	-05:00
:	Separator	{0:hh:mm:ss}	10:34:23
/	Separator	{0:dd/MM/yyyy	14/11/2007