hi!

I'm trying to execute this line but its not working.

Code:
txtdate=format(now,"yyyy/mm/dd")
the result should be 2010/05/19 instead its 05/19/2010. I'm using vb6 and mysql.I'm trying to compare the date in my database and the current date.and since the date format of mysql is yyyy/mm/dd i need to format the current date for them to meet.is there something missing in my code?


Thanks!