Feature Request Summary:

Create new custom field type, Date as a timestamp.

Description:

The granularity of current date custom field is a day. If we set any date to the date field, in Explore while building statistics we will see something like “2024-01-30T00:00:00”, where hours/minutes/seconds are zeros. It could cause some mistakes in calculations if we try to measure time between Ticket created date and the date set to one of those custom fields. For example, a ticket was created at “2024-01-30T16:45:00” and an agent set to a custom field date of, let's say, when the discount was provided “2024-01-30” (the same day, but few hours later after ticket was created). If we calculate the time difference between two of those dates, we would get a negative number, like -16 hours, because hours/mins/seconds were not stored.

Business impact of limitation or missing feature:
1. [in Explore] The absence of such precision doesn't let us calculate exact amount of hours between system events in Zendesk and our custom events, thus we can't build our custom KPIs that measure agents reaction in various workflows.

2. Also, when we use date comparison in triggers or automations, we can compare only dates, but it's not possible to compare date of events where the exact time matters, consequently, we can't run triggers and automations closer to the actual date of condition we require to be satisfied.