1. In Layout mode, select one or more date fields or calculation fields with a date result.
2. In the Inspector, click the Data tab.
3. In the Data Formatting area, click Date , then select the formats you want to use from the Format list.
To display dates | Do this |
Exactly as entered | For Format, select As entered. |
In a predefined format | For Format, select a format. To change the separator between parts of a numeric date, for Numeric separator, type another character. |
In a custom format | For Format, select Custom and choose options. |
With leading zeros (as in | In the Leading character area, choose options. |
With different text formatting | Select text options using the Appearance tab in the Inspector. See Specifying text formats for fields. |
Using a different Japanese date display (if you’re using a font that contains Japanese characters) | In the Japanese area, for Numeral type, choose a display type. |
Using the current system formats for dates | For Format, select Short System Date (for example, 11/11/2019) or Long System Date (for example, Monday, November 11, 2019). FileMaker Pro Advanced formats dates based on the current system formats when the file is opened. |
4. Press Enter or Tab, or click outside the Inspector to apply the changes.