Time Zone Issues with CSV Export

When entries are entered AFTER 8PM Eastern Time (New York), and then an export is done for the date those entries are made, those entries do not show. They DO show on the next day's export. However, the data in the entry fields is all correct, the issue only seems to be with the exported csv files.

Example:
Form entry submitted on 1/7/12
Export downloaded on 1/8/12, and the export dates are both set to 1/7/12.
Any entry made AFTER 8PM on 1/7/12 does NOT appear on the export file.

If the export dates are changed to 1/7/12 through 1/8/12, those entires made after 8pm on 1/7 DO appear in that csv file. The entry date shows correctly, 1/7/12, but they only show up in 1/8/12 export file.

I imagine it has to do with my server being in a different time zone, and therefore MySQL is using a different time, but is there a workaround?

Thanks!

MySQL does read "localhost"

Server is in Utah, and is on RMT. Client is in Connecticut, EST. Wordpress General settings are set for clients local time (Using the "New York" option in Wordpress.). It's important to the client that form entries are made at the correct local time/date.

Also, I just ran an export, and the file was named with the date for tomorrow, not today. So obviously, the export is pulling UTC/GMT and is not compensating for the wordpress setting of minus 4.

Thanks Chris. The sooner I can get a workaround, the better.

The fields in the CSV file are 100% correct, as I would like them.

The titles of the csv files created after 8PM include the wrong file name. EG if I create an export tonight at 8:27PM EST, it will be called form-name-2013-01-10.csv when it should read todays date.

The entries included in an export, though I select 1/8/2013 for both start and end, will include any entries made after 8PM on 1/7/2013, and will not include any entries made after 8PM on 1/8/2013.

The 1/7/2013 entries included on 1/8/2013 export will list 1/7/2013 as their entry date, so that portion is correct. The form entry data is correct. It is only the GMT localization conversion in the export procedure that is wrong.

Am I being clear, or am I just muddling it up more? I have a tendency to ask confusing questions so please let me know if I need to rephrase, happy to do so!

Thanks so much you all for your help!

WOW!!! This is incredible, so excited to try it out.
I sent you an email Chris.
Please extend my thanks to everyone involved.

CHris, I just responded via email. The CSV export is now completely blank. All Entries are intact in the admin, it just sends me a blank file.

Any word on this?

The patch worked great so far! Thanks for this.