I have about 230 files and I want to prefix a date starting with 2006-09-11 (yyymmdd) and then incrementing by 7 days for each filename.
eg: Before
weeklyCashSpend-001.xls
weeklyCashSpend-002.xls
weeklyCashSpend-003.xls
weeklyCashSpend-004.xls
After (hopefully)
weeklyCashSpend-2009-09-11.xls
weeklyCashSpend-2009-09-18.xls
weeklyCashSpend-2009-09-25.xls
weeklyCashSpend-2009-10-02.xls
I am ok with moving the date characters around within the file names,
Does BRU have a way to autonumber with dates?
Could BRU convert a sequence number into a date (Like Excel converts date-sequence-numbers since 1900-01-01 into dates)
any other suggestions welcomed
regards
Mark