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.