Help dealing with a date string

[StargazeR82]

I'm using a MySQL backend with ASP/VBScript. On an update page for orders there are several dates. When viewed on the page, the data is in the format mm/dd/yy. But for it to be input into the database, it must be in the format yyyy/mm/dd. So when you go to update a record, you see the date in a human readable format, but when you click update, it puts in a screwey value in the database. example: exchanging the year for the month etc. Does anybody have a script example for converting a date string?

 

[onpnt]

faq333-3194 should help

____________________________________________________
[sub]The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924[/sub]

http://www.onpntwebdesigns.com