How do I copy the formatted date to the clipboard?

Use the /c option to copy the formatted date and time directly to the Windows clipboard:

NOW yyyy-mm-dd /c

The result is copied to the clipboard and ready to paste into any application.