Export Date Fields Include Time « Gravity Support Forums

Gravity Support Forums » General » Feature Requests

Dale
Member

We have the need to export data in CSV format so we can import it into other databases.

After exporting selected fields, the Date field, (the date that a person submits the form) includes the time of day. See below:

Entry Date
9/20/11 19:17
9/20/11 10:58
9/13/11 11:58

Consequently, the contents of that field contain the 24 Hour times in addition to the dates. This makes for 'clutter' when importing this data into our other database.

Is there a way that the Time part can be excluded in the export function?

Posted 12 years ago on Tuesday July 10, 2012 | Permalink
David Peralty

We don't have any hooks currently that will allow you to change the export. You mention that you select a date field, are you saying your form has a date field that users have been selecting or you've been auto populating a date to?

Posted 12 years ago on Tuesday July 10, 2012 | Permalink
Dale
Member

Thanks David,

We do not have a Date field(from the Advanced fields) in the form .

The export is including the Entry Date that is automatically included.

Posted 12 years ago on Tuesday July 10, 2012 | Permalink
Chris Hajer
Key Master

Moved to feature requests.

As David explained, there is no way to modify this before or during export. You would have to process the data before importing into your database to remove the time.

Posted 12 years ago on Tuesday July 10, 2012 | Permalink
David Peralty

If you use a date field in your form and pre-populate it with the current date, then when you export, you'll just have the date, and no time as the date field we include in our form fields doesn't include time.

http://www.gravityhelp.com/documentation/page/Gform_pre_submission

Posted 12 years ago on Tuesday July 10, 2012 | Permalink