Export of orders shows incorrect date format

daveturner101
Topic Author
Offline

12 years 1 month ago - 12 years 1 month ago #165989 by daveturner101

Export of orders shows incorrect date format was created by daveturner101

-- HikaShop version -- : 2.2.3

Hi,

When exporting order data to a CSV using the mass action tool, the order_created column contains the date as follows:

Saturday, 02 March 2013

When i've used the export tool in the past the order_created column has contained the date like this:

2013-02-28 12:02:06

Why is the format different when using the mass action tool? Can I change this date format somewhere?

Last edit: 12 years 1 month ago by daveturner101. Reason: wrong format

Please Log in or Create an account to join the conversation.

Xavier
Offline

12 years 1 month ago #166031 by Xavier

Replied by Xavier on topic Export of orders shows incorrect date format

Hi,

The format is indeed different, thanks to edit the file:
"administrator/components/com_hikashop/classes/massaction" function "displayByType()" and add:

Code:

$format = 'Y-m-d H:i:s';

Just before:

Code:

$square = hikashop_getDate($element->$column,$format);

The following user(s) said Thank You: daveturner101

Please Log in or Create an account to join the conversation.

daveturner101
Topic Author
Offline

12 years 1 month ago #166133 by daveturner101

Replied by daveturner101 on topic [SOLVED] Export orders shows incorrect date format

Worked a charm, thanks

Please Log in or Create an account to join the conversation.

Time to create page: 0.156 seconds