3 Replies Latest reply on Sep 13, 2016 11:29 AM by philmodjunk

    Format

    satcowitz

      I've set all of my timestamp fields to a custom format (yyyy/mm/dd hh:mm:ss). When I click in one of these fields to edit, however, the format reverts to the original format (mm/dd/yyyy hh:mm:ss).

       

      How can I get FileMaker to always show the custom format, even when I'm editing the field?

        • 1. Re: Format
          philmodjunk

          Using that method, you can't and still have it be a time field. The layout format specifies the format displayed, data entry format is controlled by the system settings on your computer (locality) and what you select in File >> File Options on the Text tab.

          2 of 2 people found this helpful
          • 2. Re: Format
            jormond

            Typically, you will want to create a text field that you allow the "editing" in. Then have your actual date be a calculation, or set the field based on the value of the edit field.

            • 3. Re: Format
              philmodjunk

              You can also use the OnValidateObject trigger to perform a script that first confirms that the data has been entered into a valid format that you want and then converts the entered data into the value and data type needed for entry into the timestamp field. This trigger will trip and run the script before the data type driven validation kicks in and complains that you've entered data with an incorrect format.

               

              I've used this trick, for example, to set up a date field where I enter only the month and the year with the trigger controlled script then providing a 1 for the day in order to enter a valid date, but formatted to show month and year only as I had no need to specify the day in that special case.