# Date Time Range and UTC Calculation Issues

**URL:** <https://community.fibery.io/t/date-time-range-and-utc-calculation-issues/3483>\
**Category:** Bugs & Issues\
**Created:** [November 6, 2022, 10:44pm UTC](https://community.fibery.io/t/date-time-range-and-utc-calculation-issues/3483 "2022-11-06T22:44:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tommy\_Hedley](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tommy_hedley/32/6468_2.png) [@Tommy\_Hedley](https://community.fibery.io/u/Tommy_Hedley)\
**Post date:** [November 6, 2022, 10:44pm UTC](https://community.fibery.io/t/date-time-range-and-utc-calculation-issues/3483/1 "2022-11-06T22:44:38Z")

</div>

Hi everyone, apologies in advance if this issue has be covered. I did a bit of searching first and I was unable to find any info on it.

I was messing around with [https://community.fibery.io/t/relative-time-task-planning-board/3261](https://community.fibery.io/t/relative-time-task-planning-board/3261) and adding some of my own tweaks when I noticed that the time duration calculation for a date time range will calculate incorrectly if the selected date is the same as today. This issue also seems to affect the time zone conversion for formulas and automations. This is pretty easy to work around by adding an If(Day(Date) = Day(Today()), but it doesn’t seem like it should be working this way.

Calculation Error:

 ![Date Time Range Calculation Error - Calc](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/4/4eeee7f62b3ebc17adfab6d498205678d9ff21d6.png)  
 ![Date Time Range Calculation Error - UI](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/cc7b8f5bb05398b9db2413364be3f83392e1314e.png)

UTC Offset Error:  
For context the “Tomorrow” column is calculated as Today() + Days(1) to show that the issue seems to be with Dates set to Today()

 ![Date Time Range Calculation Error - UTC Off](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/e3c5e11878ff1e4ae9be4e5061384d74a1b1e1f6.jpeg)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [November 6, 2022, 10:52pm UTC](https://community.fibery.io/t/date-time-range-and-utc-calculation-issues/3483/2 "2022-11-06T22:52:06Z")

</div>

Is it possible that the problem is due to daylight saving time?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/7340065acc4c974743aef14d0a5372a8459f1d18.png)

Unfortunately, there are 13 hours between midnight and 12noon on 6th November 2022 for most of USA and Canada (!)

---

<div class="post-metadata">

**Author:** ![Tommy\_Hedley](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tommy_hedley/32/6468_2.png) [@Tommy\_Hedley](https://community.fibery.io/u/Tommy_Hedley)\
**Post date:** [November 6, 2022, 11:01pm UTC](https://community.fibery.io/t/date-time-range-and-utc-calculation-issues/3483/3 "2022-11-06T23:01:53Z")

</div>

_Forehead Slap_ Haha thanks @Chr1sG, of course I would be messing with time duration calculations on the only day that there would be issues. Sorry about that!