Skip to main content
Solved

In the "Date and Time" field, when I perform automations on it, it treats it as if it were GMT/UTC even though I defined my own time zone.

  • April 26, 2025
  • 1 reply
  • 37 views

Forum|alt.badge.img+7

Hello.
My time zone is Israel.
I defined the time zone of Israel in the Date and Time field. But when I run formulas or automation on it, it refers to the registered time, as if it were GMT/UTC and this disrupts all my automations.
Is there a solution for this?

Best answer by Alexey_Gusev

Hi,

In formulas, it depends on that switch, when you enter Formatting.
 



About Automations - more details needed, how do you trigger them? Usually I’m not targeting time field directly, I found more convenient to make a kind of formula displaying like “X minutes to GO” or “Started” when the counter value (measured by DATETIME_DIFF() ) is <=0. And trigger “When the record matches conditions” (field value is “Started”)

1 reply

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1261 replies
  • Answer
  • April 27, 2025

Hi,

In formulas, it depends on that switch, when you enter Formatting.
 



About Automations - more details needed, how do you trigger them? Usually I’m not targeting time field directly, I found more convenient to make a kind of formula displaying like “X minutes to GO” or “Started” when the counter value (measured by DATETIME_DIFF() ) is <=0. And trigger “When the record matches conditions” (field value is “Started”)