[Skip to main content](#vessel-content) # Date question with CSV export ## - **[mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile")** - [![mbolton01's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6461-mbolton01 "View mbolton01's Profile") Topic Author - [ Offline](/forum/user/6461-mbolton01) Less More - Posts: 3 - Thank you received: 0 - - 14 years 8 months ago [\#41688](#41688) by [mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile") *[Date question with CSV export](/forum/3-bug-report/41688-date-question-with-csv-export#41688 "I searched the forum and could not find an answer to this problem I am seeing. When I export orders from the sales screen, the order_created and order_modified fields do not display as a date in Excel 2007. When I attempt to apply the date format I get all "#" displayed in the Excel cell. However, registerdate and lastvisit date display fine in excel. I am using 1.5.6 starter with Joomla 2.5.1, and the default semicolon as the delimeter for the CSV file. Can someone please help with this?")* was created by *[mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile")* I searched the forum and could not find an answer to this problem I am seeing. When I export orders from the sales screen, the order_created and order_modified fields do not display as a date in Excel 2007. When I attempt to apply the date format I get all "#" displayed in the Excel cell. However, registerdate and lastvisit date display fine in excel. I am using 1.5.6 starter with Joomla 2.5.1, and the default semicolon as the delimeter for the CSV file. Can someone please help with this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MTY4OC1kYXRlLXF1ZXN0aW9uLXdpdGgtY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile")** - [![mbolton01's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6461-mbolton01 "View mbolton01's Profile") Topic Author - [ Offline](/forum/user/6461-mbolton01) Less More - Posts: 3 - Thank you received: 0 - - 14 years 7 months ago [\#41836](#41836) by [mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile") Replied by *[mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile")* on topic *[Re: Date question with CSV export](/forum/3-bug-report/41688-date-question-with-csv-export#41836 "I searched the forum and could not find an answer to this problem I am seeing. When I export orders from the sales screen, the order_created and order_modified fields do not display as a date in Excel 2007. When I attempt to apply the date format I get all "#" displayed in the Excel cell. However, registerdate and lastvisit date display fine in excel. I am using 1.5.6 starter with Joomla 2.5.1, and the default semicolon as the delimeter for the CSV file. Can someone please help with this?")* Could you please point me in the right direction to understand these dates? I want to upgrade to the business version but I need to know I can get the right data to download to quickbooks... Thanks in advance... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MTY4OC1kYXRlLXF1ZXN0aW9uLXdpdGgtY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 7 months ago [\#41860](#41860) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Date question with CSV export](/forum/3-bug-report/41688-date-question-with-csv-export#41860 "I searched the forum and could not find an answer to this problem I am seeing. When I export orders from the sales screen, the order_created and order_modified fields do not display as a date in Excel 2007. When I attempt to apply the date format I get all "#" displayed in the Excel cell. However, registerdate and lastvisit date display fine in excel. I am using 1.5.6 starter with Joomla 2.5.1, and the default semicolon as the delimeter for the CSV file. Can someone please help with this?")* Hi, These fields use the unix timestamp format which is not understood by excel as a date. If you want to change that, you need to edit the file "export" of the view "order" of your back end template via the menu Display->Views and add the code: Code: if(in_array($key,array('order_created','order_modified'))){ $val=hikashop_getDate($val); } before the code: Code: echo '"'.str_replace('"','""',$val).'"'; Then, when you export, you should get dates properly displayed by excel. The following user(s) said Thank You: [mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MTY4OC1kYXRlLXF1ZXN0aW9uLXdpdGgtY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile")** - [![mbolton01's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6461-mbolton01 "View mbolton01's Profile") Topic Author - [ Offline](/forum/user/6461-mbolton01) Less More - Posts: 3 - Thank you received: 0 - - 14 years 7 months ago - 14 years 7 months ago [\#41863](#41863) by [mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile") Replied by *[mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile")* on topic *[Re: Date question with CSV export](/forum/3-bug-report/41688-date-question-with-csv-export#41863 "I searched the forum and could not find an answer to this problem I am seeing. When I export orders from the sales screen, the order_created and order_modified fields do not display as a date in Excel 2007. When I attempt to apply the date format I get all "#" displayed in the Excel cell. However, registerdate and lastvisit date display fine in excel. I am using 1.5.6 starter with Joomla 2.5.1, and the default semicolon as the delimeter for the CSV file. Can someone please help with this?")* Thank you, I will try this today... Works great - Thank you very much... Last edit: 14 years 7 months ago by [mbolton01](/forum/user/6461-mbolton01 "View mbolton01's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MTY4OC1kYXRlLXF1ZXN0aW9uLXdpdGgtY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[raydesign](/forum/user/6588-raydesign "View raydesign's Profile")** - [![raydesign's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6588-raydesign "View raydesign's Profile") - [ Offline](/forum/user/6588-raydesign) Less More - Posts: 4 - Thank you received: 0 - - 14 years 7 months ago [\#42586](#42586) by [raydesign](/forum/user/6588-raydesign "View raydesign's Profile") Replied by *[raydesign](/forum/user/6588-raydesign "View raydesign's Profile")* on topic *[Re: Date question with CSV export](/forum/3-bug-report/41688-date-question-with-csv-export#42586 "I searched the forum and could not find an answer to this problem I am seeing. When I export orders from the sales screen, the order_created and order_modified fields do not display as a date in Excel 2007. When I attempt to apply the date format I get all "#" displayed in the Excel cell. However, registerdate and lastvisit date display fine in excel. I am using 1.5.6 starter with Joomla 2.5.1, and the default semicolon as the delimeter for the CSV file. Can someone please help with this?")* Nicolas, I'm experiencing the same issue with the dates when exporting sales as CSV. I tried to add the code you provided, but I can not get it to work. I still get the ### when formatting as date in excel. Could you please post an example of the original code, WITH the added code inside, so I can see exactly where it goes? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MTY4OC1kYXRlLXF1ZXN0aW9uLXdpdGgtY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 7 months ago [\#42721](#42721) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Date question with CSV export](/forum/3-bug-report/41688-date-question-with-csv-export#42721 "I searched the forum and could not find an answer to this problem I am seeing. When I export orders from the sales screen, the order_created and order_modified fields do not display as a date in Excel 2007. When I attempt to apply the date format I get all "#" displayed in the Excel cell. However, registerdate and lastvisit date display fine in excel. I am using 1.5.6 starter with Joomla 2.5.1, and the default semicolon as the delimeter for the CSV file. Can someone please help with this?")* If you don't see any difference, it's probably that you edited the file for the wrong template. Make sure that you do it for your back end template and it will work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC80MTY4OC1kYXRlLXF1ZXN0aW9uLXdpdGgtY3N2LWV4cG9ydD90bXBsPW1hcmtkb3du) 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.064 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)