https://legacy.forums.gravityhelp.com/topic/gform_save_field_value-datepicker-errors Gravity Support Forums Topic: gform_save_field_value datepicker errors en-US Sun, 19 Apr 2026 23:27:34 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/gform_save_field_value-datepicker-errors#post-301331 Tue, 04 Jun 2013 11:00:15 +0000 David Peralty 301331@https://legacy.forums.gravityhelp.com/ <p>Sorry about that. All my best! </p> https://legacy.forums.gravityhelp.com/topic/gform_save_field_value-datepicker-errors#post-300947 Tue, 04 Jun 2013 08:06:54 +0000 reddishpink 300947@https://legacy.forums.gravityhelp.com/ <p>Oh, okay. That's a bit frustrating since it makes the dates unsortable in the database when the date field is used. Thanks for your reply. </p> https://legacy.forums.gravityhelp.com/topic/gform_save_field_value-datepicker-errors#post-281426 Mon, 27 May 2013 19:11:59 +0000 David Peralty 281426@https://legacy.forums.gravityhelp.com/ <p>You can't just change our date field to save data in a different way than we've programmed it. </p> <p>If you want to do this, then your best bet is to use a regular input field, add a CSS class to it, and manually hook the JQuery datepicker script to that field. Then you can have full control over how the date is saved in the database. </p> https://legacy.forums.gravityhelp.com/topic/gform_save_field_value-datepicker-errors#post-281283 Mon, 27 May 2013 16:32:11 +0000 reddishpink 281283@https://legacy.forums.gravityhelp.com/ <p>Hello. I'm trying to use gform_save_field_value to save a date from a datepicker field (formatted d/m/Y) into iso format (Y-m-d). My original code is:</p> <p>add_filter("gform_save_field_value", "save_iso_date", 2, 9);<br /> function save_iso_date($value, $lead, $field, $form) {<br /> list($day, $month, $year) = explode("/", $value);<br /> return sprintf('%s-%s-%s', $year, $month, $day);<br /> }</p> <p>So, for a date given in the datepicker as 06/05/2013, this adds the value in the database as '--2013-05-06' for instance. If I replace '%s-%s-%s' with something like '%s/%s/%s' it results in '//2013-05-06'. If I drop the first two characters like so:</p> <p> return substr(sprintf('%s-%s-%s', $year, $month, $day), 2);</p> <p>then what's added to the db is the original string 06/05/2013. Something weird is happening. Am I going about this the right way? </p>