I'm using this batch file to backup my database, appending the day of the month to the end of the file name (so that I will always have a month's worth of backups).
However, when the batch file runs, it copies the file without appending. Anyone know why that would be?
set DATE=%date% <- extracts date from system date command
set DAY=%DATE:~7,2% <- extracts two characters starting at 8th (0-7)
COPY "F:\AccessDatabase\Merchandising.accdb" C:\Users\Me\Desktop