Hello everyone,

I have a file that comes in daily that has the format: filename_yyyymmdd.txt. What I need to do is rename only the file that matches today's date. For example: filename_20100419.txt . So I'm trying to use the {DATEFORMAT(yyyyMd)} variable, but that results in: 2010419. Notice that if the month is a single digit (like April), then it doesn't add the 0 in there. Now I could add the zero in the variable, but come October, the job would fail. Any ideas?

More I look at it, I noticed that with a Rename File task, there is no option to file based on filename...is there another way to do this?

Thanks!

Try using two M's:

{DATEFORMAT(yyyyMMdd)}

---

Try using two M's:

{DATEFORMAT(yyyyMMdd)}

Ohhh that works! Thanks!

The more I look at it, I noticed that with a Rename File task, there is no option to filter based on filename using a variable...is there another way to do renames?

Basically what I'm looking to do is rename: filename_{DATEFORMAT(yyyyMMdd)} -> newfilename.txt

Which version are you running? You just specify that variable in the "Include file mask".

---

Which version are you running? You just specify that variable in the "Include file mask".

We're running 5.5.5. That did the job - Thank you!