Insert Date and Time into backup file name
I have a backup script that runs every time the file is closed that backs up the file to a USB HDD. It works fine, except that when it backs up it overwrites the previous backup.
What I would like it to do is insert a timestamp into the actual backup file name so that every backup is kept.
I tried naming the file "backup & Get ( CurrentDate )," or for the timestamp, but neither worked.
Any way to do this?