Thanks, but adding this line causes an error.

Quote Originally Posted by jolivanes View Post
Format(Now(), "yyyy-mmmm-dd")
'or maybe
Format(Now(), "mmmm-dd-yyyy")