Skip to content

Dates in File Save Names

Tips for using dates in file save names.

Q:  Luis Pelaez writes to say that he is having a problem creating a document save name with a formatted date.

A:  You can have problems if you use slashes in file names, such as the standard mm/dd/yyyy date format.  I use a custom format, such as Format(Date(), “mm-dd-yyyy”).  You can create whatever date format you want, and so long as it doesn’t contain illegal characters, it should work in a file name.

About this author