Date, Date/Time, and Time fields
Key Takeaway
Pick the data type carefully, because changing a custom field to or from Date or Date/Time can cause data loss.
Date, Date/Time, and Time are three custom field data types that record when something happens. The right data type depends on whether a value needs a date, a time of day, or both. Time fields also follow their own rules for time zones and formula math.
What each data type stores
- A Date field stores a calendar date. In reports, you can filter data by specific dates using any custom Date field.
- A Date/Time field stores a date plus a time of day, with AM or PM notation. Its precision is in seconds. In reports, you can filter by specific dates and times.
- A Time field stores a time of day with no date at all, including hours, minutes, seconds, and milliseconds. Its precision is in milliseconds, and it displays in 12-hour notation with AM or PM.