I get the same as you using your code.
It must have something to do with the format command
using a registered word for format. I don't know.

There is no need to use a variable at all.
Just do this:

Text1 = Format(Date, "yyyy/mm/dd")