PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Export Date Fields Include Time

Gravity Support Forums » General » Feature Requests

  1. 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 11 years ago on Tuesday July 10, 2012 | Permalink

  2. 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 11 years ago on Tuesday July 10, 2012 | Permalink

  3. 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 11 years ago on Tuesday July 10, 2012 | Permalink

  4. 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 11 years ago on Tuesday July 10, 2012 | Permalink

  5. 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 11 years ago on Tuesday July 10, 2012 | Permalink