Character(s) Display(s) Example
ddd
The name of the day abbreviated. The
rst letter is capitalized if the selected
locale uses capitalized day names.
'Monday’ with the format ddd gives ‘Mon’ in
English, in French, lundi gives lun.
Dddd
Forced the capitalization of the day
name, for any locale.
'Monday’ with the format Dddd gives ‘Mon’ in
English, in French, lundi gives Lun.
dddd
The name of the day in full. The rst let
ter is capitalized if the selected locale
uses capitalized day names.
‘Monday’ with the format dddd gives ‘Mon
day’ in English. In French, the day is lundi.
DDDD
The name of the day in full, in upper
case.
‘Monday’ with the format DDDD gives ‘MON
DAY’ in English. In French, the day is LUNDI.
dddd dd
The day of the week followed by a
space and the number of the day.
‘Monday’ with the format dddd dd gives
‘Monday 01’
Calendar characters
(week, month, year)
M
The number of the month with no lead
ing zeros. If the number for month is
less than two characters, the number
displays without a zero before it.
‘January’ with the format M gives '1'
MM
The number of the month with leading
zeros. If the number for month is less
than two characters, the number dis
plays with a zero before it.
‘January’ with the format MM gives '01'
mmm
The name of the month abbreviated.
The rst letter is capitalized if the se
lected locale uses capitalization.
‘January’ with the format mmm gives Jan in
English. In French, this is 'jan'.
Mmmm
The name of the month abbreviated.
The rst letter is capitalized for all lo
cales.
‘January’ with the format mmm gives Jan in
English. In French, this is 'Jan'.
mmmm
The name of the month in full. The rst
letter is capitalized if the selected lo
cale used capitalization.
‘January’ with the format mmmm gives January
in English, janvier in French
MMMM
The name of the month in full all in up
percase.
‘January’ with the format MMMM gives JANU
ARY in English, JANVIER in French
ww
The week number of the year.
For the 9th of January 2015, the ww format
gives '02', because it is the seventh week of
the year 2015.
w
The week number of the year without
leading zero.
For the 9th of January 2015, the w format
gives '2', because it is the seventh week of the
year 2015.
W
The week number of the month.
For the 9th of January 2015, the W format
gives '2', because it is the second week of
January.
yy
The last two digits for year.
‘2003’ with the format yy gives ‘03’
yyyy
All four digits for year.
‘2003’ with the format yyyy gives ‘2003’
574 P U B L I C
SAP BusinessObjects Web Intelligence User's Guide
Analyzing data