Timezone for week of year with standard calculated attribute | Community
Skip to main content

Timezone for week of year with standard calculated attribute

  • July 24, 2021
  • 1 reply
  • 0 views
M

Hello guys

can you help me with a calculated field?

I'm trying to reduce 8 hours of time zone to be accurate with my data.

tried something like:

(LEFTPART((DATE_ADD([Ticket solved - Week of year],"Hour", -8)),10))

but it didn't work, do you have any suggestions?

Thanks.

    1 reply

    Heather13
    • Heather13
    • July 29, 2021

    Hi Maycon Aranha,

    What are you trying to achieve here? Is this for reporting? I'm wondering if you might be better served setting up business hours and timezones there and setting them on the tickets and you'll have an easier time when exporting data/Exploring.

    Terms & ConditionsCookie settingsAccessibility statement