Buy Now
Sign in

After Submitting a Form with Info, there is a 7 Hour Time Difference between Create Date & Modified Date

itadminguy , July 26 at 02:22
i
itadminguy

Hey Bob. I tried to search for a prior solution to this problem, but not luck.

When I process a form, there is a 7 hour time difference between the create date and modified date.

created modified
2017-07-26 02:09:57 2017-07-25 19:09:57

the table settings for the form are

created datetime [0000-00-00 00:00:00]
modified datetime NULL


In the past, I have had to go in and change my php settings with the host by changing the php date from Europe time to U S Pacific time. Maybe this only changed the "created date"? Maybe I never noticed that the Modified date is still "stuck" on Europe time?

When I setup my table for each new form, I never touch the created datetime or the modified datetime.

Should they both read the same?

created datetime [0000-00-00 00:00:00]
modified datetime [0000-00-00 00:00:00]

Or does it even matter?

Note that I have additional date fields (which are U S Pacific time) which are in the table and the email output.

It would be ideal if the created and modified datetimes matched up.

Is there a different php setting for modified datetime?

Thanks in advance.