🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.golive.dynamic.content
Article #26

Formatting a user input date

#26
From: Jeremy_M._Cox
Date: Fri, 25 Jun 2004 14:38
8 lines
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!webx

Show 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