you could use the format function of vbScript format(string, "yyyy-mm-dd")
The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. ----- Original Message ----- From: "Dana Shields" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 08, 2003 9:13 AM Subject: Date Conversion with UltraDev (ASP) I am using MySQL with Ultradev (asp server model), and I'm creating a recordset insert form; however, the documenation is obvious that the user has to enter the date in yyyy-mm-dd format. However, this will not work for my users, and I need to allow them to enter mm/dd/yyyy or even mm/dd/yy format. Does anyone know of an ultradev extension (for ASP) that will convert to the MySQL date format? This is easily handled with MS Access and SQL Server, so hopefully there's something out there that does this as well. If anyone thinks this posting is misplaced and should be in an Ultradev list, please feel free to let me know. Thank you. Dana --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
