# .csv Import End Date is 1 Day Early

**URL:** <https://community.fibery.io/t/csv-import-end-date-is-1-day-early/8328>\
**Category:** Bugs & Issues\
**Created:** [February 22, 2025, 1:57pm UTC](https://community.fibery.io/t/csv-import-end-date-is-1-day-early/8328 "2025-02-22T13:57:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![daoud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daoud/32/11021_2.png) [@daoud](https://community.fibery.io/u/daoud)\
**Post date:** [February 22, 2025, 1:57pm UTC](https://community.fibery.io/t/csv-import-end-date-is-1-day-early/8328/1 "2025-02-22T13:57:30Z")

</div>

This is strange: I am importing date ranges per [Import from CSV](https://the.fibery.io/@public/User_Guide/Guide/Import-from-CSV-67) with the date format as “DD Mmm YYYY - DD Mmm YYYY”. For some reason, the imported range end dates are one day earlier.

 ![Screenshot 2025-02-22 at 06.54.54](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/e63894f87b9908570e69f454188814ef80f2b67a.png)

 ![Screenshot 2025-02-22 at 06.55.33](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/a/a9b4397f1c167a263076f0c50c3e09f2f9c19d68.png)

---

<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:** [February 22, 2025, 2:33pm UTC](https://community.fibery.io/t/csv-import-end-date-is-1-day-early/8328/2 "2025-02-22T14:33:23Z")

</div>

It’s possibly an effect of the way date ranges are stored:  
[https://the.fibery.io/@public/User\_Guide/Guide/Date-Ranges-in-Formulas-42](https://the.fibery.io/@public/User_Guide/Guide/Date-Ranges-in-Formulas-42)

---

<div class="post-metadata">

**Author:** ![daoud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/daoud/32/11021_2.png) [@daoud](https://community.fibery.io/u/daoud)\
**Post date:** [February 22, 2025, 4:18pm UTC](https://community.fibery.io/t/csv-import-end-date-is-1-day-early/8328/3 "2025-02-22T16:18:55Z")

</div>

Are you saying it’s a bug or “working as designed”? If the latter, then recommend [Import from CSV](https://the.fibery.io/@public/User_Guide/Guide/Import-from-CSV-67) be updated to clarify this point.

---

<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:** [February 22, 2025, 5:17pm UTC](https://community.fibery.io/t/csv-import-end-date-is-1-day-early/8328/4 "2025-02-22T17:17:02Z")

</div>

I would say it’s a bug (and let’s hope a dev can fix it soon 🤞)