https://legacy.forums.gravityhelp.com/topic/dynamically-populating-date-field Gravity Support Forums Topic: Dynamically Populating Date Field en-US Thu, 09 Apr 2026 07:47:05 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/dynamically-populating-date-field#post-72636 Sun, 26 Aug 2012 03:42:41 +0000 theslink2000 72636@https://legacy.forums.gravityhelp.com/ <p>No worries bud. Hope someone finds it useful. </p> https://legacy.forums.gravityhelp.com/topic/dynamically-populating-date-field#post-72620 Sun, 26 Aug 2012 00:51:51 +0000 Chris Hajer 72620@https://legacy.forums.gravityhelp.com/ <p>We'll leave it open. Thanks for posting how you resolved your problem. </p> https://legacy.forums.gravityhelp.com/topic/dynamically-populating-date-field#post-72600 Sat, 25 Aug 2012 12:01:37 +0000 theslink2000 72600@https://legacy.forums.gravityhelp.com/ <p>I've worked it out, there was a syntax error, my bad! I tried for hours before posting here, sorry.</p> <p>For anyone wondering Gravity Forms and I'm assuming Wordpress and PHP and SQL in general store dates as timestamps. This is what threw me as the time stamp is the number of seconds since 00:00 01/01/1970 the timestamp was created. Sounds weird but that's what date() does, it decodes this.</p> <p>To complete my editing code I needed to modify the after_submission function to this:</p> <pre><code>//Update the existing monitor dosage system type post on submitting the form function update_dob($entry) { $timestamp = strtotime($entry[2]); update_post_meta($entry[1], &quot;wpcf-patient-date-of-birth&quot;, $timestamp); //Update the post (stored in field 1), field name and the new value (stored in field 3) }</code></pre> <p>Note the use of the strtotime() function to create the new timestamp. Once this is done it's working beautifully.</p> <p>The above code is now correct and is working for me. It's up to the admins if they want to delete this thread or not as I've sorted myself out, but I couldn't find this in the documentation so it may prove useful. </p> https://legacy.forums.gravityhelp.com/topic/dynamically-populating-date-field#post-72592 Sat, 25 Aug 2012 11:08:24 +0000 theslink2000 72592@https://legacy.forums.gravityhelp.com/ <p>Hi,</p> <p>I'm trying to dynamically populate a date field so that the user can see the existing entry and then update it using the date field (with date picker) as normal. </p> <p>This process has not been a problem for every other field type I've tried and I'm sure it's not for the Date Field, however I can populate the field but the field isn't interpreting the data as I expected. I've used a date field to save the data (in this case the original date is 08/12/1965 and that's how it outputs around the site, but the database stores it as -128304000. Obviously this must be correct as everything else seems to understand it, so I expected when I passed it back to the Date Field as a string it would understand it and convert it, but it doesn't it just displays -128304000.</p> <p>I can find no mention of this in the documentation or elsewhere in these forums, could someone help me interpret this please? </p> <p>Here's my code, as you can see I've tried using the php date() function, but to no effect:</p> <pre><code>add_filter(&#39;gform_field_value_original_dob&#39;, &#39;original_dob&#39;); //Dynamically populate the original dob field //Populate the original date of birth edit field function original_dob() { $post_id = $_GET[&#39;original_post_id&#39;]; //Pass GET function to pull variable from query string $post_field = &quot;-date-of-birth&quot;; //Supply the bit of the field name specific to this item $data = populate_edit_field($post_id, $post_field); //Build full funtion to find the required item of data $date = date(&#39;d/m/Y&#39;, $data); return $date; } //Function to build the command to and find the field data function populate_edit_field ($post_id, $post_field) { $post_type = get_post_type($post_id); //Use get_post_type to find the type of post, this is used as the part of the field name that changes for each type, such as &quot;wpcf-surgery-street-address&quot; $database_field = &quot;wpcf-&quot; . $post_type . $post_field; //Build complete field name $post_data = find_post_data($post_id, $database_field, true); //Finally find the contents of the field and post it back to the form return $post_data; } //Retrieve post meta based on the post id passed via query string to the form function find_post_data($postid, $fieldname, $returntype) { global $post; //Call the global $post variable to access stored data $value = get_post_meta($postid, $fieldname, $returntype); //Return the contents of the requested field for the passed post id return $value; } add_action(&quot;gform_after_submission_26&quot;, &quot;update_dob&quot;, 10, 2); //Update the edited date of birth in the database //Update the existing monitor dosage system type post on submitting the form function update_dob($entry) { update_post_meta($entry[1], &quot;wpcf-patient-date-of-birth&quot;, $entry[2]); //Update the post (stored in field 1), field name and the new value (stored in field 3) }</code></pre>