3 Replies Latest reply on Jul 25, 2012 4:27 PM by JodieWeston

    US date field format



      US date field format


      Does anyone know how to set up a field as US format?  Not just the way it is displayed, but it needs to be exported in US format.

      Jodie :)

        • 1. Re: US date field format

          Internally, date fields are the number of days since Jan 1, 1900.

          There is a default format and this is what is exported.

          Home > Designing and creating databases > Editing objects on layouts > Formatting and setting up field objects in Layout mode > 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:
          In Layout mode, select one or more date fields or calculation fields with a date result.
          For more information, see Selecting objects.
          Click Inspector Inspector button in the layout bar, then click Data.
          In the Data Formatting area, click DateDate button, 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.
          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.
          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, 2010 needs more room than 5/5/10. For more information, see Resizing and reshaping objects.
          To format a date symbol (which displays the current date), select the symbol “//” (two slashes) 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.

          • 2. Re: US date field format

            Actually, it's the number of days since 12/31/0000 Wink (event the FileMaker Training Series book is off by one on this one.)

            When exporting records, there's an option to "use current layout's data formatting when exporting". So if you use that option with a layout that specifies the desired date format, you should get the result that you need.

            • 3. Re: US date field format

              You're a star!! Works perfectly :)