# Date reduced by 1 day

**URL:** <https://forum.wixstudio.com/t/date-reduced-by-1-day/18284>\
**Category:** Ask the community\
**Tags:** code, question\
**Created:** [June 12, 2019, 1:05pm UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284 "2019-06-12T13:05:10Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![pinoyusedcarsco](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/pinoyusedcarsco/32/12587_2.png) [@pinoyusedcarsco](https://forum.wixstudio.com/u/pinoyusedcarsco)\
**Post date:** [June 12, 2019, 1:05pm UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284/1 "2019-06-12T13:05:10Z")

</div>

Date from database are being reduced by 1 day when putting into textbox.

eg.

Database:  
06/01/2019 00:00

when being output on

**let** myDate= event.rowData[“myDate”]  
$w(“#InputUpdateMyDate”).value = myDate;

2019-05-31T20:00:00.000Z

---

<div class="post-metadata">

**Author:** ![mark23345](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/mark23345/32/36845_2.png) [@mark23345](https://forum.wixstudio.com/u/mark23345)\
**Post date:** [August 16, 2024, 4:20pm UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284/2 "2024-08-16T16:20:14Z")

</div>

No reply from Wix and I’m having the same issue. What a wonderfully thoughtful professional company

---

<div class="post-metadata">

**Author:** ![V-Blog](https://avatars.discourse-cdn.com/v4/letter/v/898d66/32.png) [@V-Blog](https://forum.wixstudio.com/u/V-Blog)\
**Post date:** [August 16, 2024, 4:40pm UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284/3 "2024-08-16T16:40:41Z")

</div>

Try this, not sure it will work though… [Changing Your Site's Regional Settings | Help Center | Wix.com](https://support.wix.com/en/article/changing-your-sites-regional-settings)

---

<div class="post-metadata">

**Author:** ![onemoretime](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onemoretime/32/104023_2.png) [@onemoretime](https://forum.wixstudio.com/u/onemoretime)\
**Post date:** [August 16, 2024, 5:22pm UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284/4 "2024-08-16T17:22:42Z")

</div>

Hello! It seems that this might be due to a difference in time zones. The server operates in UTC, but on the database, the date is displayed according to your local time zone. Therefore, if you generate text without considering the time zone, the resulting date text may differ from what you expected.

---

<div class="post-metadata">

**Author:** ![codequeen](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/codequeen/32/88960_2.png) [@codequeen](https://forum.wixstudio.com/u/codequeen)\
**Post date:** [August 16, 2024, 6:59pm UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284/5 "2024-08-16T18:59:43Z")

</div>

I do not believe it has anything to do with time zones. Wix acknowledged there was a bug and that they were working on it.

It was reported yet again in February that a different date would appear when it was connected differently.

 ![IMG_0749](https://us1.discourse-cdn.com/wix/original/3X/1/4/144819000fa65db61b80687b2f36ee337ba7abc8.jpeg)

 ![IMG_7429](https://us1.discourse-cdn.com/wix/original/3X/5/d/5d878ef6daffabfe6da28d15edad0c6a33dce542.jpeg)

 ![IMG_0751](https://us1.discourse-cdn.com/wix/original/3X/4/2/426620ca888dc234b301832a77f100a104c35322.jpeg)

---

<div class="post-metadata">

**Author:** ![onemoretime](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/onemoretime/32/104023_2.png) [@onemoretime](https://forum.wixstudio.com/u/onemoretime)\
**Post date:** [August 17, 2024, 2:22am UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284/6 "2024-08-17T02:22:38Z")

</div>

I didn’t know there was such a bug…! Thank you, Code Queen!

---

<div class="post-metadata">

**Author:** ![Tinh\_Hoa](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/tinh_hoa/32/87029_2.png) [@Tinh\_Hoa](https://forum.wixstudio.com/u/Tinh_Hoa)\
**Post date:** [August 17, 2024, 3:12am UTC](https://forum.wixstudio.com/t/date-reduced-by-1-day/18284/7 "2024-08-17T03:12:28Z")

</div>

Guys, this’s been happened like over 5 years 🤣 please fix, instead of simply linking CMS to table, i have to code my table in pain 🥲
