Hi all.

I have a form that people fill out which allows them to enter a date. Not to much of a problem here, I have them fill out the date as 0000-00-00 (year, month, day) as MySQL relies on...

and this writes to my database successfully.

my problem is on the my "modify page". the user can open a form that calls in all the data they entered and can make changes. The date field that gets called in from MySQL turns the dates back to slashes and in a normal date format (00/00/000).

How can I get .asp classic to format the date to display YYYY-MM-DD OR convert back to MySQl before updating itself?

Thank you.

This thread http://p2p.wrox.com/topic.asp?TOPIC_ID=28552 and this URL http://classicasp.aspfaq.com/date-ti...es-for-me.html should solve your problem.


================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========