logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
9.0.4 How to deal with date/time when exporting orders into Excel
Options
Go to last post Go to first unread
Previous Topic Next Topic
Joe Payne @ Solunar  
#1 Posted : Monday, March 7, 2022 3:27:52 PM(UTC)
Joe Payne @ Solunar

Rank: Member

Groups: Developers, Registered, HelpDesk
Joined: 11/7/2018(UTC)
Posts: 23

Thanks: 5 times
The order export works great, except the OrderDate field comes into Excel as the huge full datetime format including timezone offset. Excel doesn't recognize the column as a date value.

How do you get Excel to recognize that OrderDate value as a date so it can be formatted properly?
Joe Payne, AbleMods Hosting LLC
https://www.ablemodshosting.com
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
ray22901031  
#2 Posted : Monday, March 7, 2022 4:11:23 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 827

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
Joe,

There are many ways to do this.

#1 On a new column, format it first to your date format
#2. Then try this "=DATEVALUE(LEFT(B2,10))"

Where B2 is the long date/time format.

Hope this help,
-Ray

Image1.jpg (480kb) downloaded 13 time(s).

Edited by user Monday, March 7, 2022 4:14:54 PM(UTC)  | Reason: Not specified
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.134 seconds.