The date format uses the letters ‘d’, ‘M’ and ‘y’ to represent various ways of displaying day, month and year. Note that the ‘M’ must be upper case since a lower case ‘m’ is used for minutes. Any other characters used are displayed exactly as you enter them.

The codes are:

         d                   day number (no leading zero)

         dd                 day number (two digits)

         ddd               abbreviated weekday

         dddd             full weekday

         M                  month number (no leading zero)

         MM               month number (two digits)

         MMM           abbreviated month name

         MMMM        full month name

         yy                  last two digits of year

         yyyy              all four digits of year

Here are some examples for displaying 3 September 2007.

         d MMMM yyyy                              3 September 2007

         dd/MM/yy                                    03/09/07

         dddd, d MMM yyyy                       Monday, 3 Sep 2007

         MMMM d                                      September 3