Question

Add a Date/Time field to the list of available custom fields

  • 22 February 2022
  • 1 reply
  • 506 views

I would like to recommend that Freshdesk add a Date/Time field to the list of available custom fields to prevent the backend from converting to the wrong date for analytics.  Currently, when using the custom Date field (without time) it is converted by the backend to UTC (date) time and the time defaults to DD Mmm 00:00 AM.  When the date is pulled into analytics, the time is converted to the agent’s timezone. Depending on the agent’s location, the date may be converted to one day prior resulting in inaccurate analytics dates. 

Example:

Transaction date: 15 Feb 2022

Backend sets date to UTC 15 Feb 2022 at 00:00 AM

Conversion from UTC to to Agent’s EST (-5 hours):

   15 Feb 2022 at 00:00 AM - 5 hours = 14 Feb 2022 at 07:00 PM


1 reply

Userlevel 1
Badge +6

I’ve seen issues like this in other products like MS Power automate/flow - it seems to be a common issue in many products. Upvoting this!

Reply