# Time zone displacement out of range - Report

**URL:** <https://community.fibery.io/t/time-zone-displacement-out-of-range-report/5965>\
**Category:** Bugs & Issues\
**Created:** [March 12, 2024, 1:49pm UTC](https://community.fibery.io/t/time-zone-displacement-out-of-range-report/5965 "2024-03-12T13:49:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Daniel\_Chiniquy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daniel_chiniquy/32/6955_2.png) [@Daniel\_Chiniquy](https://community.fibery.io/u/Daniel_Chiniquy)\
**Post date:** [March 12, 2024, 1:49pm UTC](https://community.fibery.io/t/time-zone-displacement-out-of-range-report/5965/1 "2024-03-12T13:49:46Z")

</div>

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

I’m getting an error when trying to create a report based on a data set of devices (7000+ rows). I know this did not happen previously, but I’m not sure exactly when it started.

The dataset has the following date fields:  
Purchase Date (without Time or start/end dates)  
Service Expiry Date (without Time or start/end dates)  
Legacy - Billable from (without Tme or start/end dates)  
As well as the normal Created and Changed dates.

Our local timezone is GMT+1.

Any known issues that could cause this? Could this be related to the leap day recently?

---

<div class="post-metadata">

**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\
**Post date:** [March 12, 2024, 5:14pm UTC](https://community.fibery.io/t/time-zone-displacement-out-of-range-report/5965/2 "2024-03-12T17:14:26Z")

</div>

Hi, Daniel!  
We have an assumption, that it can be that one of the records from your data set has the wrong date, either too big or too small.  
Can that be the case? 👀

---

<div class="post-metadata">

**Author:** ![Daniel\_Chiniquy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daniel_chiniquy/32/6955_2.png) [@Daniel\_Chiniquy](https://community.fibery.io/u/Daniel_Chiniquy)\
**Post date:** [March 13, 2024, 7:52am UTC](https://community.fibery.io/t/time-zone-displacement-out-of-range-report/5965/3 "2024-03-13T07:52:45Z")

</div>

Could be, how would I go about checking that? It’s 7000+ rows so would rather not do it manually 😛

---

<div class="post-metadata">

**Author:** ![Daniel\_Chiniquy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daniel_chiniquy/32/6955_2.png) [@Daniel\_Chiniquy](https://community.fibery.io/u/Daniel_Chiniquy)\
**Post date:** [March 13, 2024, 7:59am UTC](https://community.fibery.io/t/time-zone-displacement-out-of-range-report/5965/4 "2024-03-13T07:59:20Z")

</div>

I’ve quickly scanned through using a CSV export, and the latest date I can find is 2029-04-30. And the earliest is 2013-12-03. I can’t seem to find any wrongly formatted dates.  
I could remove some sensitive columns and send over a copy of the data?

---

<div class="post-metadata">

**Author:** ![Daniel\_Chiniquy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daniel_chiniquy/32/6955_2.png) [@Daniel\_Chiniquy](https://community.fibery.io/u/Daniel_Chiniquy)\
**Post date:** [March 13, 2024, 9:06am UTC](https://community.fibery.io/t/time-zone-displacement-out-of-range-report/5965/5 "2024-03-13T09:06:16Z")

</div>

Finally found the date that was wrong. Seems like it was removed from the CSV export at first as an error during formatting somehow, so didn’t find it until I managed to narrow it down more. All good.