https://legacy.forums.gravityhelp.com/topic/export-date-fields-include-time Gravity Support Forums Topic: Export Date Fields Include Time en-US Mon, 20 Apr 2026 13:24:25 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/export-date-fields-include-time#post-65598 Tue, 10 Jul 2012 14:21:44 +0000 David Peralty 65598@https://legacy.forums.gravityhelp.com/ <p>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. </p> <p><a href="http://www.gravityhelp.com/documentation/page/Gform_pre_submission" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_pre_submission</a> </p> https://legacy.forums.gravityhelp.com/topic/export-date-fields-include-time#post-65595 Tue, 10 Jul 2012 14:11:12 +0000 Chris Hajer 65595@https://legacy.forums.gravityhelp.com/ <p>Moved to feature requests.</p> <p>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. </p> https://legacy.forums.gravityhelp.com/topic/export-date-fields-include-time#post-65566 Tue, 10 Jul 2012 12:27:39 +0000 Dale 65566@https://legacy.forums.gravityhelp.com/ <p>Thanks David,</p> <p>We do not have a Date field(from the Advanced fields) in the form . </p> <p>The export is including the Entry Date that is automatically included. </p> https://legacy.forums.gravityhelp.com/topic/export-date-fields-include-time#post-65561 Tue, 10 Jul 2012 12:21:17 +0000 David Peralty 65561@https://legacy.forums.gravityhelp.com/ <p>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? </p> https://legacy.forums.gravityhelp.com/topic/export-date-fields-include-time#post-65554 Tue, 10 Jul 2012 12:00:08 +0000 Dale 65554@https://legacy.forums.gravityhelp.com/ <p>We have the need to export data in CSV format so we can import it into other databases. </p> <p>After exporting selected fields, the Date field, (the date that a person submits the form) includes the time of day. See below:</p> <p>Entry Date<br /> 9/20/11 19:17<br /> 9/20/11 10:58<br /> 9/13/11 11:58</p> <p>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.</p> <p>Is there a way that the Time part can be excluded in the export function? </p>