Editing objects, layout parts, and the layout background > Formatting and setting up field objects in Layout mode > Specifying formats for date fields

Specifying formats for date fields

1. In Layout mode, select one or more date fields or calculation fields with a date result.

2. In the Inspector, click the Data Data tab.

3. In the Data Formatting area, click Date Date button, 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
01/02/99) or leading spaces in numeric parts of dates

In the Leading character area, choose options.

With different text formatting

Select text options using the Appearance 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.

Related topics 

Defining conditional formatting for layout objects

Setting up a field to display a drop-down calendar

About date fields