change time stamps

**spid3r1987** · 21 Jul 2009, 09:26 PM

Tue, 21 Jul 2009 15:18:53 -0500GMT [

im not at -0500
im london gmt
how do i change this??
also when i add products. i set the date added to 21/07/2009
but the product states
This product was added to our catalog on Tuesday 30 November, 1999

WHAAA?? i wasn't even online then lol!

**DrByte** · 21 Jul 2009, 11:02 PM

Originally Posted by spid3r1987

Tue, 21 Jul 2009 15:18:53 -0500GMT [

im not at -0500
im london gmt

If you're referring to the date/time information in your admin menu bar, that comes directly from the server hosting your website. That's *its* clock detail.

Originally Posted by spid3r1987

how do i change this??

You're not meant to. However, if it's a problem, there is a Time Zone Offset addon which you could experiment with if you're feeling lucky.

Originally Posted by spid3r1987

also when i add products. i set the date added to 21/07/2009
but the product states
This product was added to our catalog on Tuesday 30 November, 1999

Since the current version of the Zen Cart UI doesn't offer the option of setting the date-added manually, I must assume that you're making such edits manually using something like phpMyAdmin.
When making raw database edits, it's VERY important that you follow the same formatting conventions as the server itself uses. In the case of MySQL, proper date/time notation follows a specific format. For dates, it's YYYY-MM-DD.
Since you've entered the date in the wrong format, it's displaying a default fallback value when the data is retrieved.

**spid3r1987** · 21 Jul 2009, 11:33 PM

products are added via easypopulate
text delimited file.
v_products_added
20/07/2009

etc..
i can explain more if required??
or try upload a template of the TxT file i use?

**DrByte** · 21 Jul 2009, 11:41 PM

Perhaps you need to change your date format in your spreadsheet to MM/DD/YYYY in order for EasyPopulate to properly parse it?
I don't use EasyPopulate, so am probably not the one to answer questions related to it.

**spid3r1987** · 22 Jul 2009, 12:12 AM

Originally Posted by DrByte

Perhaps you need to change your date format in your spreadsheet to MM/DD/YYYY in order for EasyPopulate to properly parse it?
I don't use EasyPopulate, so am probably not the one to answer questions related to it.

exactly that
im using UK date format
if i switch to US format its got the correct date on it.