Page 1 of 1

Auto Numbering with Dates

PostPosted: Tue Jun 14, 2011 1:20 pm
by mjb
Hi,

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