Date problem when adding featured product

[nickgreaves]

Version 1.3.9b

Catalog -> Featured Products

Select a product from the list

Use the arrow alongside the available date field to pull down the calendar and select a date

Do the same for the expiry date

The dates in those fields now have a / at the beginning which means that when you click on "insert", dates in 2036 are entered instead of the correct ones. Removing the / from each field before clicking on "insert" makes it WAD.

I've read the thread at http://www.zen-cart.com/forum/showth...d+product+date regarding this problem. I have edited the two english.php files per https://www.zen-cart.com/tutorials/i...hp?article=401 so I went and checked through the relevant sections of each very carefully to see if I had made an error. I found none.

Dates elsewhere on the site - both in Admin and the Online Catalog - work fine.

Regards

Nick

[Ajeh]

I am not reproducing a problem on the dates using the calendars ...

Have you changed anything about the dates in the Admin?

[nickgreaves]

Have you changed anything about the dates in the Admin?

Only the edits to the english.php files to change to UK date format, as referred to above. No other changes.

Regards

Nick

[nickgreaves]

A bit more background to this:

It was working fine in 1.3.8, prior to the upgrade. Since the upgrade I have re-edited the new english.php files in admin and the catalog (per the FAQ) to the UK date format. As a sanity check, I have checked all of the edits again.

In Catalog -> Featured Products when I pull down the calendar and select a date, it is posted into the date field in the form:

/03/05/2010 (note the dd/mm/yyyy format and the fact that the initial / which is causing the problem).

In Catalog -> Categories/Products if I define or edit a product, pull down the calendar there for "Date Available" and select a date, it is posted into the field in the form:

2010-05-03 (which works fine when I preview and save it).

Regards

Nick

[Ajeh]

Have you been able to resolve this issue or is it still a problem for you?

[nickgreaves]

Still the same. I've just been manually editing out the leading /

Regards

Nick

[Ajeh]

In the:
/admin/includes/languages/english.php

Are you using:

define('DATE_FORMAT_SPIFFYCAL', 'dd/mm/yyyy');

Or are you using:

define('DATE_FORMAT_SPIFFYCAL', 'dd/MM/yyyy');  //Use only 'dd', 'MM' and 'yyyy' here in any order

[nickgreaves]

The second:

define('DATE_FORMAT_SPIFFYCAL', '/dd/MM/yyyy'); //Use only 'dd', 'MM' and 'yyyy' here in any order

[nickgreaves]

Ah, Eureka. Just seen the problem!

Doh! How did I miss that.

Of course it's working fine now (not surprisingly).

Thanks for pointing me in the right direction.

Nick

[Ajeh]

I just tried a v1.3.8 with /admin/includes/languages/english.php changed from:
define('DATE_FORMAT_SPIFFYCAL', 'MM/dd/yyyy'); //Use only 'dd', 'MM' and 'yyyy' here in any order

to be:
define('DATE_FORMAT_SPIFFYCAL', 'dd/MM/yyyy'); //Use only 'dd', 'MM' and 'yyyy' here in any order

and the same issue exists ...

There is a problem with the definition as to adding the dates in that format ...

However, this appears to be an error also in v1.3.8 ...

We will look into this further ...