Currently, when you export data from a form using a specified date range, the date range is based on Greenwich Mean Time. We are on Pacific Standard Time, so when we export data using the date range feature, we get records whose date submitted is after 5pm the day before the specified start date and up to 5pm the day before the specified end date. It is very inconvenient to calculate the correct times to get the data from the actual date range we want. Is there a way to base the date range on the time zone specified in the admin settings? |