convert todays date to a MYSQL timestamp format

[starlev]

I am trying to convert today?s date to a MYSQL timestamp format
the code I?m using to make the MYSQL timestamp format is

myTimestamp = Date
myTimestamp = Format(myTimestamp, "yyyy-mm-dd")

However when I send information to MySQL I get an empty date.
What am I doing wrong?

[6StringJazzer]

How is myTimestamp declared? You should declare all your variables and the result must be a String. Also you can put Date right in the Format call, no intermediate assignment necessary..

My recommendation is

Please Login or Register  to view this content.

[starlev]

Thank you for your help
I used the following code and it worked

Please Login or Register  to view this content.

[6StringJazzer]

That is different than your original question. Also, there is still no need to use an intermediate variable. You can just put Now directly in the Format call.

Also I'll repeat that variables should be declared. I strongly recommend to everyone that they use Option Explicit and declare variables. Doing so prevents a lot of bugs and runtime errors.