[Skip to main content](#vessel-content) # Date Format in sales exports ## - **[yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile")** - [![yellowhousejake's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile") Topic Author - [ Offline](/forum/user/4221-yellowhousejake) Less More - Posts: 37 - Thank you received: 0 - - 13 years 7 months ago [\#94189](#94189) by [yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile") *[Date Format in sales exports](/forum/2-general-talk-about-hikashop/79226-date-format-in-sales-exports#94189 "What format is being used in the sales table to record dates? It is exporting a CSV format, but Excel and Open Office cannot use the date provided. Thanks, DAve")* was created by *[yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile")* What format is being used in the sales table to record dates? It is exporting a CSV format, but Excel and Open Office cannot use the date provided. Thanks, DAve Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjI2LWRhdGUtZm9ybWF0LWluLXNhbGVzLWV4cG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14274 - - 13 years 7 months ago [\#94388](#94388) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Date Format in sales exports](/forum/2-general-talk-about-hikashop/79226-date-format-in-sales-exports#94388 "What format is being used in the sales table to record dates? It is exporting a CSV format, but Excel and Open Office cannot use the date provided. Thanks, DAve")* I'm not sure if you're talking about the CSV of the sales reports of the CSV of the orders. The sales reports CSV uses the RFC 822 format and the orders CSV use the format %Y-%m-%d %H:%M:%S Normally, you can change the date format in excel options so that the date get properly recognized: [ stackoverflow.com/questions/12766595/dat...wertab=votes#tab-top](http://stackoverflow.com/questions/12766595/date-format-different-in-actual-filecsv-and-the-excel-file?answertab=votes#tab-top) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjI2LWRhdGUtZm9ybWF0LWluLXNhbGVzLWV4cG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile")** - [![yellowhousejake's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile") Topic Author - [ Offline](/forum/user/4221-yellowhousejake) Less More - Posts: 37 - Thank you received: 0 - - 13 years 7 months ago [\#94392](#94392) by [yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile") Replied by *[yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile")* on topic *[Date Format in sales exports](/forum/2-general-talk-about-hikashop/79226-date-format-in-sales-exports#94392 "What format is being used in the sales table to record dates? It is exporting a CSV format, but Excel and Open Office cannot use the date provided. Thanks, DAve")* Hmmm nope. I have this in MySQL and the orders export CSV for the order_modified field. 1331044648 Excel doesn't recognize it. RFC 822 is an email RFC. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjI2LWRhdGUtZm9ybWF0LWluLXNhbGVzLWV4cG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14274 - - 13 years 7 months ago [\#94399](#94399) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Date Format in sales exports](/forum/2-general-talk-about-hikashop/79226-date-format-in-sales-exports#94399 "What format is being used in the sales table to record dates? It is exporting a CSV format, but Excel and Open Office cannot use the date provided. Thanks, DAve")* That's the unix timestamp of the date. You must be using an old version of HikaShop as the CSVs use human readable format for dates since a few releases. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjI2LWRhdGUtZm9ybWF0LWluLXNhbGVzLWV4cG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile")** - [![yellowhousejake's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile") Topic Author - [ Offline](/forum/user/4221-yellowhousejake) Less More - Posts: 37 - Thank you received: 0 - - 13 years 7 months ago [\#94400](#94400) by [yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile") Replied by *[yellowhousejake](/forum/user/4221-yellowhousejake "View yellowhousejake's Profile")* on topic *[Date Format in sales exports](/forum/2-general-talk-about-hikashop/79226-date-format-in-sales-exports#94400 "What format is being used in the sales table to record dates? It is exporting a CSV format, but Excel and Open Office cannot use the date provided. Thanks, DAve")* We are on 1.5.6. We made a lot of modifications so we were hesitant to upgrade. It works pretty well with no real problems, so the desire was not there. We have a business subscription, but I don't know that we will upgrade until we upgrade Joomla. Sorry for not noticing the format, it just did not jump out at me that it was a Unix Time Stamp. Thanks, DAve Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzc5MjI2LWRhdGUtZm9ybWF0LWluLXNhbGVzLWV4cG9ydHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.111 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)