Layout Design - FileMaker Pro 13: The Missing Manual - page 415

▪ ss shows a time as just a number of seconds. Every minute counts as 60 seconds, and
every hour as 60 minutes. They're added up along with the seconds themselves to pro-
duce the final number.
▪ Short System Time shows a time as defined by the operating system and can be con-
figured in your system settings (Windows or Mac). Typically, the Short System time
shows hours and minutes, with AM or PM ( 8:23 AM ).
▪ Long System Time is also defined by the OS, and typically shows hours, minutes, and
seconds, with AM or PM ( 8:23:54 AM ).
Normally time values show a colon between each number. You can change this look if you
want by typing something else in the Separator box. To leave out the separator entirely, clear
the box. (This method lets you make military-style times, like 0730 .)
When displaying clock time, FileMaker can use 24-hour or 12-hour notation. In other words,
do you want to see 14:23 or 2:23 PM ? When you choose “24 hour,” you can add some arbit-
rary text before or after the value (23:00UTC, for instance). When using 12-hour notation,
you get to decide what text you want to represent a.m. and p.m. by typing in the “before
noon” and “after noon” boxes.
You can choose from the pop-up menu to the right of these labels to put them on either side
of the time value. Like a date value, you get to tell FileMaker how to handle single-digit
numbers. Again, you can leave them as a single digit, add a leading space, or add a leading
zero.
Timestamp Formatting
Although FileMaker has a timestamp field (see Time ) , the Inspector doesn't have a
timestamp option. Remember that timestamp fields really contain two values: a date and a
time. So, you use the Date formatting options (the button with the calendar icon) to control
how the date part of a timestamp looks, and the Time formatting options (the button with the
clock icon) for the time portion.