you can use the code following:

Format(now, "yyyy-dd")

Best Regards
John Black

"mvyvoda" wrote in message
...
i need to use DateSerial for this format 2005-11. how the heck do i do
that?

thanks,
mark