Question

Expression Builder: Working with time

  • 8 February 2023
  • 1 reply
  • 182 views

Userlevel 2
Badge +2

Hello!

 

We are hitting some issues with some expression builder date functions. I have a form that a manager submits for others and they enter in a date and time of execution as well as a custom dropdown that contains a list of timezones. I have a custom object that maps the timezones to a time offset. We want to build an expression that will spit out the UTC time of execution for the user that they submitted it for in the timezone that was selected int he dropdown. This is what we have:

addHours('{{ticket_date_iso}}', {{offset}})

This didn’t work because the “ticket_date_iso” accounts for the users timezone so my UTC offset math doesn’t work. I was wondering if there was a way to get the timezone of the user, subtract the offset there, and then add the offset of the user its being submitted for but I can’t find a way to get the timezone of the user who submitted it.

 

Anyone else have a similar use case that they found a solution for?


1 reply

Userlevel 6
Badge +11

Hi.

You may try using an API call to get the Timezone of the requester:

https://api.freshservice.com/#requesters

 

This should work. Haven't tried it though.

 

Sincerely,

Elvis

Reply