Article View: adobe.golive.dynamic.content
Article #26Formatting a user input date
From: Jeremy_M._Cox
Date: Fri, 25 Jun 2004 14:38
Date: Fri, 25 Jun 2004 14:38
8 lines
1424 bytes
1424 bytes
Is there a possibility to allow a user to enter the date dd-mm-yyyy in a text input field and covert it to MySQL format yyyy-mm-dd so that it goes in a "date" field in the database. I got it to work with the hidden input field. But can it work with user input dates. Example. I am allowing an administrator to add meeting minutes or reports to a data base. One of the fields is meeting_date with the type Date in MySQL. So the administrator would physically type in the date in a input text field. Rather than having them type in the format yyyy-mm-dd I would like them to be able to type something they are used to mm-dd-yyyy. I looked at the strings about date formatting but they were all using the current date in a hidden input object. Oh and I am using php/mysql and golive 6.01 with the dc beta updates.
Technical Details
Message-ID:
<3bb4c65d.-1@webx.la2eafNXanI>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!webxShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 11ffd2,8502de635f9b659d,start X-Google-Attributes: gid11ffd2,public From: Jeremy_M._Cox@adobeforums.com Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!webx Newsgroups: adobe.golive.dynamic.content Subject: Formatting a user input date Message-ID: <3bb4c65d.-1@webx.la2eafNXanI> Date: Fri, 25 Jun 2004 07:38:13 -0700 Lines: 17 MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit