Specifying formats for date fields

Specifying formats for date fields

You can control how FileMaker Pro displays the values in date fields and calculation fields with date results.

To specify formats for date fields:

1.

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

For more information, see Selecting objects.

2.

Click Inspector in the layout bar, then click Data.

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

Select As entered.

In a predefined format

Choose a format.

To change the separator between parts of a numeric date, for Numeric separator, type another character.

In a custom format

Select Custom and choose options and separator characters for day of week, month, day of month, and year.

With leading zeros (as in
01/02/99) or leading spaces in numeric parts of dates

In the Leading character area, choose <None>, Zero, Space for For day numbers, For month numbers, or both. (This option is not available if you've chosen As entered.)

With different text formatting

Select text options using the Appearance tab of the Inspector. For more information, 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.

4.

Press Enter or Tab, or click outside the Inspector to apply the changes.

Important No matter how you format a date field in Layout mode, whenever you click or tab into the field in Browse mode, FileMaker Pro displays the date with a four-digit year. FileMaker recommends that you always enter dates with four-digit years. If you enter dates with two-digit years, they are converted to four-digit year dates as described in Conversion of dates with two-digit years.

Notes

•

When As entered is selected, FileMaker Pro will display dates with four-digit years, even if you originally entered the dates with two-digit years. Use the Custom option or one of the two-digit year options on the Format list described above to display dates with two-digit years.

•

Be sure to size the date field on the layout according to the format you choose. For example, the date Monday, May 5, 2014 needs more room than 5/5/14. For more information, see Resizing and reshaping objects.

•

To format a date symbol (which displays the current date), select the symbol {{CurrentDate}} in Layout mode, and then use the Data Formatting area of the Inspector to format it as you would a date field as described above. For more information about the date symbol, see Inserting the date, page number, or other variable onto a layout.

•

To make it easier to enter dates in a field in Browse mode, you can set up the field to display a drop-down calendar.

•

For more information about defining date fields, see Defining date fields.

Related topics

Defining conditional formatting for layout objects

To display dates	Do this
Exactly as entered	Select As entered.
In a predefined format	Choose a format. To change the separator between parts of a numeric date, for Numeric separator, type another character.
In a custom format	Select Custom and choose options and separator characters for day of week, month, day of month, and year.
With leading zeros (as in 01/02/99) or leading spaces in numeric parts of dates	In the Leading character area, choose <None>, Zero, Space for For day numbers, For month numbers, or both. (This option is not available if you've chosen As entered.)
With different text formatting	Select text options using the Appearance tab of the Inspector. For more information, 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.

Was this topic helpful? Send feedback.