Hello,
I am wondering if there is a Filter I can add to my functions.php file, to change the default auto-created Entry Time (when the submission is created) from UTC to my time zone (-5). I feed forms into a leads sheet for my client and they are getting confused as to why someone submitted a form at 1AM the next day, when it was really 7PM the current day. I hunted in the forums and documentation and could not find anything.
Note, wordpress time zone is set correctly.
Hi Rachel. By default, the entry time is stored in the WordPress database in UTC, and converted to local time based on your WordPress timezone setting. If that is not happening, there could be a mismatch with the PHP time and MySQL time. You can check the Gravity Forms System Report for that (Forms > System Status in the WordPress dashboard.)
If none of that points to a problem, the filter you use to modify the date offset depends on how the entries are being fed into your lead sheet. How are you doing that currently?
Hello,
I have the same problem, is there a solution? When I select to filter the entries by entry date, select greater than and input a date, it comes up with entries that are on the prior date after 8pm. I am in eastern time zone.
| WordPress (Local) Timezone | America/New_York |
|---|---|
| MySQL - Universal time (UTC) | 2021-04-14 23:04:33 |
| MySQL - Local time | April 14, 2021 at 7:04 pm |
| PHP - Universal time (UTC) | 2021-04-14 23:04:33 |
| PHP - Local time | April 14, 2021 at 7:04 pm |
How can I make sure the filter shows the proper entries?
Thanks in advance for the support!
Hello. I recommend contacting support for a solution to this:
Thank you.