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.
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?