Format Property — Date/Time Data Type Example
The following are examples of custom date/time formats.
Setting | Display |
---|---|
ddd", "mmm d", "yyyy | Mon, Jun 2, 1997 |
mmmm dd", "yyyy | June 02, 1997 |
"This is week number "ww | This is week number 22 |
"Today is "dddd | Today is Tuesday |
You could use a custom format to display "A.D." before or "B.C." after a year depending on whether a positive or negative number is entered. To see this custom format work, create a new table field, set its data type to Number and enter a format as follows:
"A.D. " #;# " B.C."
Positive numbers are displayed as years with an "A.D." before the year. Negative numbers are displayed as years with a "B.C." after the year.