6.7.7.4 Standard Date Formats

There are actually ten standard date formats, numbered 0 through 9. Entering a blank line at the d d command’s prompt gives you format number 1, Calc’s usual format. You can enter any digit to select the other formats.

To create your own standard date formats, give a numeric prefix argument from 0 to 9 to the d d command. The format you enter will be recorded as the new standard format of that number, as well as becoming the new current date format. You can save your formats permanently with the m m command (see Mode Settings).

0

‘N’ (Numerical format)

1

‘<H:mm:SSpp >Www Mmm D, YYYY’ (American format)

2

‘D Mmm YYYY<, h:mm:SS>’ (European format)

3

‘Www Mmm BD< hh:mm:ss> YYYY’ (Unix written date format)

4

‘M/D/Y< H:mm:SSpp>’ (American slashed format)

5

‘D.M.Y< h:mm:SS>’ (European dotted format)

6

‘M-D-Y< H:mm:SSpp>’ (American dashed format)

7

‘D-M-Y< h:mm:SS>’ (European dashed format)

8

‘j<, h:mm:ss>’ (Julian day plus time)

9

‘YYddd< hh:mm:ss>’ (Year-day format)

10

‘ZYYY-MM-DD Www< hh:mm>’ (Org mode format)

11

‘IYYY-Iww-w<Thh:mm:ss>’ (ISO 8601 week numbering format)