Product
Support
Everything Else
Understanding Time in Helix
Time and Formats

There are five basic methods of entering dates and times into your Collection: type them in, use the Time Stamp function, the Today tile, the Form Time tile or the Post Time tile.

You may select from three display format options for a Date Field: Date only, Time only or Date and Time. The display format option you choose only affects what a Field displays; it does not affect what is stored. For each entry there is always a date and a time stored.

For an Abacus such as "Today" or "Form Time," changing the format inside the Abacus does not change what the Abacus returns. On the screen it might display only the time or the date, but the Abacus will always return both when reference by another object such as a Field or Abacus.

If you decide to type the date, the date you enter will be stored and the time will be 12:00 AM. If you decide to typet he time, the time you enter will be stored and the date will be 1/1/0001. if you decide to use the Time Stamp function, the time and date stored will be based on the format of the Date Field. If the Field is formatted for date only, then the time stored will be 12:00 AM. If the Field is formatted for time only, then the date stored will be 1/1/0001. If the field is formatted for date and time, then the full date and time will be stored.

The Today tile will store today's date; the time will be stored as 12:00 AM. The Form Time tile and the Post Time tile will store the current time adn date based on the Macintosh's built-in clock regardless of the Field's format. Form Time is set when the form first opens or when a Clear Form occurs. Post Time is set when a Post or Enter occurs.

In every version of Helix since 5.0, the "time" in a Helix network is set by the server. Thus, if a TCP/IP client in California enters data into a Helix database in New York at 9:00am in California, the record will show as being entered at 12:00pm.