Database Reference
In-Depth Information
between text. This process continues until the last text box is added to the result. By mixing
and matching text and date values, you can make a date look any way you want.
If you don't want to use one of the date values, then from the relevant pop-up menu, choose
“<None>.” Likewise, to skip a between text value, clear its text box. The pop-up menu but-
tons to the right of each text box give you a choice of common date-related symbols for easy
picking. They have a “<None>” option as well, if you want to quickly clear the associated
box.
When you're using preset or Custom formats, in the “Leading character” area of this win-
dow, you can use the pop-up menus to tell FileMaker how to handle single-digit month and
day numbers. If you want them left alone, choose “<None>.” To insert a leading space,
choose Space, and for a leading zero, choose Zero.
Short System Date and Long System Date
New to FileMaker 13, these options force the data in the field to be formatted as Short or
Long settings as defined by the operating system. Both OS X and Windows have system set-
tings that can be configured to display dates in either short or long formats. Examples:
▪ Short System Date: 11/11/2014
▪ Long System Date: Tuesday, November 11, 2014
Time Formatting
Compared with dates and numbers, formatting time values is a breeze—FileMaker gives you
just a few simple choices. Figure 8-16 shows the Inspector's time formatting options (click
the clock icon to activate them).
Search WWH ::




Custom Search