https://www.machform.com/forums/ MachForm Community Forums Topic: Change "date_created" format (Germany/Deutschland) en Sat, 07 Nov 2026 09:15:55 +0000 https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-11815 Tue, 12 Apr 2011 21:19:28 +0000 yuniar 11815@https://www.machform.com/forums/ <p>Can you send us your file please? We'll check it.<br /> Please send to: customer.service [at] appnitro.com </p> https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-11805 Tue, 12 Apr 2011 15:42:26 +0000 antoniovarrina 11805@https://www.machform.com/forums/ <p>Now i fix that, but Parse error: parse error in ''C:\wamp\www\o\view_entry.php on line 51''</p> <p>.... </p> https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-11804 Tue, 12 Apr 2011 15:39:30 +0000 antoniovarrina 11804@https://www.machform.com/forums/ <p>This dont work for me...</p> <p>I got error </p> <p>select date_format(date_created,'%d.%m%.%Y %H:%i:%s') date_created,date_updated,ip_address from 'ap_form_1' where id='13' Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ap_form_1' where id='13'' at line 1 </p> https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-3812 Wed, 26 Nov 2008 18:02:42 +0000 nilsmierzynski 3812@https://www.machform.com/forums/ <p>Hi redityo!</p> <p>Works great!<br /> Just replaced the ~ in your code...<br /> ~ap_form_{$form_id}~<br /> to the "backticks" and it worked fine!</p> <p>Thank you!<br /> Nils </p> https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-3805 Wed, 26 Nov 2008 09:23:31 +0000 redityo 3805@https://www.machform.com/forums/ <p>Hi Nils,</p> <p>Sorry .. since this forums can not use "backticks" it show different result. However I've update my post, please replace ~ character to "backticks" character when you copy those code to your machform file. </p> https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-3803 Wed, 26 Nov 2008 03:35:58 +0000 nilsmierzynski 3803@https://www.machform.com/forums/ <p>Hi redityo!</p> <p>Thank you. Doing this changes in the code of this two file cause this error:</p> <p>select date_format(date_created,'%d.%m%.%Y %H:%i:%s') date_created,date_updated,ip_address from ap_form_2 where id='525' Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ap_form_2 where id='525'' at line 1</p> <p>This is what I did:</p> <p>view_entry.php<br /> <code>$query = &quot;select date_created,date_updated,ip_address from</code>ap_form_{$form_id}<code>where id=&#39;$entry_id&#39;&quot;;</code></p> <p><code>$query = &quot;select date_format(date_created,&#39;%d.%m%.%Y %H:%i:%s&#39;) date_created,date_updated,ip_address from &lt;code&gt;ap_form_{$form_id}&lt;/code&gt; where id=&#39;$entry_id&#39;&quot;;</code></p> <p>and</p> <p>export_entries.php</p> <p><code>$form_data[$i][$j] = $row[$column_name];</code></p> <pre><code>if ($column_name == &#39;date_created&#39;) $form_data[$i][$j] =date(&quot;d.m.Y H:i:s&quot;,strtotime($row[$column_name])); else $form_data[$i][$j] = $row[$column_name];</code></pre> <p>What did I wrong?<br /> Rechanged everything with success.</p> <p>Thank you for your perfect support!<br /> Nils </p> https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-3795 Tue, 25 Nov 2008 14:49:52 +0000 redityo 3795@https://www.machform.com/forums/ <p>Hi,</p> <p>I'm afraid you can not directly change date format in mySQL database, since mySQL using YYYY-MM-DD format for date type. But you can get your format in view entries and excel export, to do this you should edit "view_entry.php" and "export_entries.php" files.</p> <p>1. Edit view_entry.php, search around line 51, you'll see this code :</p> <pre><code>$query = &quot;select date_created,date_updated,ip_address from ~ap_form_{$form_id}~ where id=&#39;$entry_id&#39;&quot;;</code></pre> <p>replace with this one </p> <pre><code>$query = &quot;select date_format(date_created,&#39;%d.%m%.%Y %H:%i:%s&#39;) date_created,date_updated,ip_address from ~ap_form_{$form_id}~ where id=&#39;$entry_id&#39;&quot;;</code></pre> <p>2. Edit "export_entries.php", search around line 324 you'll see this code</p> <pre><code>$form_data[$i][$j] = $row[$column_name];</code></pre> <p>replace with</p> <pre><code>if ($column_name == &#39;date_created&#39;) $form_data[$i][$j] =date(&quot;d.m.Y H:i:s&quot;,strtotime($row[$column_name])); else $form_data[$i][$j] = $row[$column_name];</code></pre> https://www.machform.com/forums/topic/change-date_created-format-germanydeutschland#post-3788 Mon, 24 Nov 2008 22:56:51 +0000 nilsmierzynski 3788@https://www.machform.com/forums/ <p>Hi!</p> <p>I love to change the format of the date_created variable.<br /> Is it just to change the this line in "post-functions.php"?</p> <p>line 927: $table_data['date_created'] = date("Y-m-d H:i:s");</p> <p>to German standard:</p> <p>line 927: $table_data['date_created'] = date("d.m.Y H:i:s");</p> <p>or are other file affected or will cause problems?<br /> Thank you!<br /> Nils </p>