Append Date to File Name

Pipe-it · Post by **Pipe-it** » Thu Dec 29, 2005 12:32 am

Hello,

Does anyone know if there is a way to append the date to the end of a filename - like "filename122805.txt" ?

Thanks & Happy New Year!

Post by **DataMystic Support** » Wed Jan 04, 2006 8:17 am

Yes, use a Restrict to Filename filter, and inside it, a Add Right Margin filter with the macro '@date'.

You may need to make the Add Right Margin filter a subfilter of a search/replace filter to get the date added in the correct spot.

Pipe-it · Post by **Pipe-it** » Mon Jan 23, 2006 6:18 am

Simon Thanks!

This works great on one of our XP machines, but we recently bought another license for our Windows 2003 Server & using the @date macro results in:

"Error,Couldn't move file [D:\Jobs\quantex\all\TXP12C.tmp] to [D:\Jobs\quantex\all\3901949_1/22/2006.xls]:The system cannot find the path specified"

When we disable (un-enable) the "Add right margin @date" part of the filter, the rest of the filiter works fine.

Thanks

Post by **DataMystic Support** » Mon Jan 23, 2006 11:31 am

From the help:
Inserts the date with the system-defined short date format

Ie, go to control panel, and set your Regional settings-short date format to the same as the other machine.

We will change this in the next release to YYYYMMDD - you can use a subsequent search/replace pattern to pickup the date format and re-arrange it. You can use this workaround until we re-release it.