# Dates from database not exporting correctly... **URL:** \ **Category:** Ask the community\ **Tags:** code, question\ **Created:** [September 26, 2018, 2:17pm UTC](https://forum.wixstudio.com/t/dates-from-database-not-exporting-correctly/4579 "2018-09-26T14:17:29Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![jasmin](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/jasmin/32/2324_2.png) [@jasmin](https://forum.wixstudio.com/u/jasmin)\ **Post date:** [September 26, 2018, 2:17pm UTC](https://forum.wixstudio.com/t/dates-from-database-not-exporting-correctly/4579/1 "2018-09-26T14:17:29Z")
I’d like to export my database as a CSV. However, when I do, the dates do not export correctly - they export as -1 day. i.e the log for the 18/09/26 is displayed as 18/09/25 in my .csv. Please can someone help? This is what I see in my live editable database in wix: ![](https://us1.discourse-cdn.com/wix/original/3X/e/1/e1f1338956838b50fe4146cc1d8b655ba86e6247.png) This is what I’m seeing in my Excel .csv export file: ![](https://us1.discourse-cdn.com/wix/original/3X/8/0/801fdcd796458437265e55bf0017907d03e10974.png) ---
**Author:** ![webmaster60841](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@webmaster60841](https://forum.wixstudio.com/u/webmaster60841)\ **Post date:** [March 27, 2019, 2:01am UTC](https://forum.wixstudio.com/t/dates-from-database-not-exporting-correctly/4579/2 "2019-03-27T02:01:49Z")
I am having the same issue. Does anyone have a solution? ---
**Author:** ![tony-brunsman](https://avatars.discourse-cdn.com/v4/letter/t/ea5d25/32.png) [@tony-brunsman](https://forum.wixstudio.com/u/tony-brunsman)\ **Post date:** [March 27, 2019, 3:21am UTC](https://forum.wixstudio.com/t/dates-from-database-not-exporting-correctly/4579/3 "2019-03-27T03:21:50Z")
The correct local time is written to the collections, but when exported, it appears to use the [UTC equivalent date and time](https://time.is/UTC) . Since I don’t no any reason why anyone would prefer that, I would consider this a bug. It would be good for one of the Wix moderators to weigh in on this. There are probably ways to deal with how it works currently if need be, but it would surely be better to correct it at its source. ---
**Author:** ![webmaster60841](https://avatars.discourse-cdn.com/v4/letter/w/9fc348/32.png) [@webmaster60841](https://forum.wixstudio.com/u/webmaster60841)\ **Post date:** [March 27, 2019, 5:08am UTC](https://forum.wixstudio.com/t/dates-from-database-not-exporting-correctly/4579/4 "2019-03-27T05:08:21Z")
Thanks Anthony. The problem is that the field I have set up is for Date of Birth, so it is always a date in the past, but it still seems to do it anyway. It is manageable if ALL the dates are wrong, but I have no way of knowing this unfortunately - it shouldn’t be dependant on what TIME people fill out the form! ---
**Author:** ![tony-brunsman](https://avatars.discourse-cdn.com/v4/letter/t/ea5d25/32.png) [@tony-brunsman](https://forum.wixstudio.com/u/tony-brunsman)\ **Post date:** [March 27, 2019, 5:48am UTC](https://forum.wixstudio.com/t/dates-from-database-not-exporting-correctly/4579/5 "2019-03-27T05:48:32Z")
@webmaster60841 What I’m observing is that all of the dates exported to Excel are what they would have been UTC time. I just now submitted something into my sandbox data, and then exported to Excel. The date written to the collection is correctly 22:28 with the right date of 3/26, but in Excel it’s 2019-03-27T05:28:22Z, seven hours later and 3/27. Pacific Time is seven hours behind UTC. I’ve checked other dates too, and also entered my birthday into a date field. It did the same thing with the date when exported except in the winter, without daylight savings time, the difference is eight hours. ---
**Author:** ![sneha](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/sneha/32/7957_2.png) [@sneha](https://forum.wixstudio.com/u/sneha)\ **Post date:** [January 4, 2023, 8:09am UTC](https://forum.wixstudio.com/t/dates-from-database-not-exporting-correctly/4579/6 "2023-01-04T08:09:10Z")
Hello , You found any solution on this. Because i got same issue . Please help me