HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Formatting numbers and dates206
Characters for formatting cells displaying date and time data
Data Type Character Displays Example
Day
d The number of the day in the
month with no leading
zeros. If the date for day is
less than two characters, the
date displays without a zero
before it.
The first day of a
month with the
format:
d gives ‘1’
dd The number of the day with
leading zeros. If the date for
day is less than two
characters, the date displays
with a zero before it.
The first day of a
month with the
format:
dd gives ‘01’
ddd The name of the day
abbreviated. The first letter is
capitalized.
‘Monday’ with the
format:
ddd gives ‘Mon’
dddd The name of the day in full.
The first letter is capitalized.
‘Monday’ with the
format:
dddd gives
‘Monday’
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’
Month
M The number of the month
with no leading 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’