Trevor
|
| Posted: 05/28/2002, 2:03 AM |
|
Using CC and PHP
This should be so easy but nothing functions today!!!!
I have a field called $fldtest_date and it has a date in it like 28 May, 2002.
All I want to do is re-format this in the Before Insert event so that it goes into MySQL correctly!
|
|
|
 |
Nicole
|
| Posted: 05/28/2002, 2:23 AM |
|
Trevor,
refer to following article that explains how to format date and where code is to be placed:
http://www.gotocode.com/art.asp?art_id=132&
|
|
|
|
Trevor
|
| Posted: 05/28/2002, 3:41 AM |
|
Hi Hellen,
This is fine but what I need is the javascript function to insert into the Before Insert event to format the data for MySQL.
Please help!
|
|
|
|
Nicole
|
| Posted: 05/28/2002, 4:05 AM |
|
Trevor,
unfortunately I cannot povide JS example, but try to search for one (date converting) on www.hotscripts.com and on www.faqts.com and assign custom onvert date function to form onsubmit event.
|
|
|
|
schaeff
|
| Posted: 05/28/2002, 4:28 PM |
|
You might want to take a look at the PHP function strtotime:
"Parse about any English textual datetime description into a UNIX timestamp"
Philippe
|
|
|
|
