Wrong Customer Account Creation date

Question

I am using Magento 1.9. In backend Manage Customer under Account Customer Account Creation on it shows wrong date.

I can't able to point out the problem can any one suggest this problem

in config.xml

<general>
            <locale>
                <code>en_US</code>
                <timezone>Asia/Calcutta</timezone>
            </locale>
        </general>

in mage.php

//date_default_timezone_set('UTC');
                date_default_timezone_set('Asia/Calcutta');

That's fine because login time is working fine Account creation time only wrong — Magento 2, Feb 12 '16 at 11:15
if you set it later then it will not effect to make sure you have right time try this in your phtml file echo date('y/m/d h:i:s'); and check the output — Qaisar Satti, Feb 12 '16 at 11:35
product view a this code and check the output... template/catalog/product/view.phtml — Qaisar Satti, Feb 12 '16 at 11:39

score 2 · Accepted Answer · answered Feb 12 '16 at 11:51

2

you have to set your timezone manually

first go to

app/etc/config.xml add your time zone here

<general>
            <locale>
                <code>en_US</code>
                <timezone>Asia/Dubai</timezone>
            </locale>
        </general>

second go to app/Mage.php

on line 768

change this line too

date_default_timezone_set('UTC');

to your timezone

date_default_timezone_set('Asia/Dubai');

answered Feb 12 '16 at 11:51

Qaisar Satti

32,469
18
85
137

where i can add can you please give me the location – Magento 2 Feb 12 '16 at 11:53
both file location are there kindly change to your timezone. – Qaisar Satti Feb 12 '16 at 11:55
Ok i will check and give you feed back soon – Magento 2 Feb 12 '16 at 11:59
still now same problem also echo date('y/m/d h:i:s'); show wrong date only – Magento 2 Feb 15 '16 at 06:01
did you do the both work add your timzone in config.xml and Mage.php – Qaisar Satti Feb 15 '16 at 06:08
Yes i added both place – Magento 2 Feb 15 '16 at 06:11
what you added can you post that? because i did that myself i have the same problem this solution work for me. – Qaisar Satti Feb 15 '16 at 06:14
Check my updated question – Magento 2 Feb 15 '16 at 06:16
did you removed th cache folder? from var/cache? – Qaisar Satti Feb 15 '16 at 06:18
yes i already did that also – Magento 2 Feb 15 '16 at 06:19
it's available only i selected from dropdown only – Magento 2 Feb 15 '16 at 06:35
it give me correct time 12:07 just change in Mage.php – Qaisar Satti Feb 15 '16 at 06:38
Share your code here – Magento 2 Feb 15 '16 at 06:40
$localConfig = simplexml_load_file($localConfigFile); date_default_timezone_set('Asia/Calcutta'); this i added on line 768 – Qaisar Satti Feb 15 '16 at 06:41
I added same code but it shows 16/02/15 12:34:43 is anything else i need to change – Magento 2 Feb 15 '16 at 07:07
this is correct now create account and check created date.. – Qaisar Satti Feb 15 '16 at 07:11
What you set in back end – Magento 2 Feb 15 '16 at 07:11
it won't work previous users – Magento 2 Feb 15 '16 at 07:11
the customer already created you cannot change the created at value for new customer check it.. – Qaisar Satti Feb 15 '16 at 07:12
Is it possible to change previous date – Magento 2 Feb 15 '16 at 08:02
While echo it shows wrong date only 16/02/15 01:32:53 – Magento 2 Feb 15 '16 at 08:03
it is not showing wrong time try with echo date('y/m/d h:i:s A'); it will show am and pm too – Qaisar Satti Feb 15 '16 at 09:03
Time is fine but year and date it showing wrong 16/02/15 03:00:07 PM – Magento 2 Feb 15 '16 at 09:30
16 is year 02 is month 15 is day ad you can see y/m/d you change d/m/Y and see the changes – Qaisar Satti Feb 15 '16 at 09:32
Oh sorry bro is it possible to change old customer date's – Magento 2 Feb 15 '16 at 09:34
change from database or create script and change the values. – Qaisar Satti Feb 15 '16 at 09:36
Ok i will check it – Magento 2 Feb 15 '16 at 09:37
it's already awarded bro – Magento 2 Feb 16 '16 at 07:59
read this how to award http://meta.stackexchange.com/questions/16065/how-does-the-bounty-system-work – Qaisar Satti Feb 16 '16 at 08:01
Sorry check now – Magento 2 Feb 16 '16 at 08:03

score 1 · Answer 2 · answered Feb 09 '16 at 14:37

1

Check your server's date & time is correct.

Check that your Magento locale settings (esp. timezone) is set properly.

answered Feb 09 '16 at 14:37

rob_st

108
1
9

How to check server time – Magento 2 Feb 09 '16 at 14:40
If you have command line access, date would most likely the command to show current date and time (-zone).
If you don't, connect via FTP, upload any file and see if the creation date and time is something near your current local time. (There might be some seconds difference due to delay caused by the actual file transfer and refreshing the directory view).
– rob_st Feb 09 '16 at 14:42
No i don't have that acess – Magento 2 Feb 09 '16 at 14:43
If you don't, connect via FTP, upload any file and see if the creation date and time is something near your current local time. (There might be some seconds difference due to delay caused by the actual file transfer and refreshing the directory view). Sorry, that part of the comment didn't go through the first time since i hit "RETURN" too fast :-) – rob_st Feb 09 '16 at 16:44
I checked server time also not a problem on that it shows current time only – Magento 2 Feb 11 '16 at 19:47
Ok, last thing I can imagine of is that MySQL time is somehow wrong. – rob_st Feb 12 '16 at 08:06
Are customer creation times always wrong or just sometimes?
I had the issue that customer creation and last-login dates weren't logged at all. Time always showed something like 1970-01-01. There's an option to enable that logging, I think it was Configuration -> Advanced/System -> Log -> Enable Log.
– rob_st Feb 12 '16 at 08:15
Some time only problem if i create today it shows correct date some previously created account time show some random month – Magento 2 Feb 12 '16 at 09:09

score 0 · Answer 3 · edited Apr 13 '17 at 12:55

0

This might be similar to Customer created_at Date off by months. I had same issue in one of my Magento.

edited Apr 13 '17 at 12:55

Community

1

answered Feb 13 '16 at 12:19

Jayesh Patel

2,118
16
22

score 0 · Answer 4 · answered Feb 15 '16 at 11:49

I faced similar issue few days back all I did was creating my custom module Namespace > Modulename > Model > Entity Attribute > Backend > Time > Created.php

copy the Created.php file from app/code/core/Mage/Eav/Model/Entity/Attribute/Backend/Time

after copying this file find and comment out the lines

$zendDate = Mage::app()->getLocale()->utcDate(null, $date, true, $this->_getFormat($date));
        $object->setData($attributeCode, $zendDate->getIso());

In both beforeSave and afterSave function. The utcDate conversion is causing this weird issue. I did the above mentioned thing and this got resolved the very next moment.

Wrong Customer Account Creation date

4 Answers4

Linked