Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Date and Date/Time fields

Log in to subscribe to topics and get notified when content changes.

Date and Date/Time fields

Records can store date and time values in several different types of fields.

These values are stored in the database as integer numbers of milliseconds, and are displayed in the appropriate date or date/time format.

Date and Date/Time field types

The following field types are provided for storing date and date/time information in records.
Table 1. Date and time field types
Field type Dictionary XML type MySQL DB type
Date glide_date DATE
Date/Time glide_date_time DATETIME
Time glide_time DATETIME
Duration glide_duration DATETIME
Due date due_date DATETIME

For the full list of field types, see Introduction to Fields.