table naming when exporting from macro

[icli]

I am doing a Transfer Text, Transfer Type: Export Fixed Width. I would like the table name to include the current date (and time if possible). Is there a way in the macro to format the table name with the date and time?

 

[Thomko]

Welcome to AWF,

you should be able to calculate the file name in the TransferText macro action with a formula like this:
=Format(Date();"yyyymmdd") & "_Filename.txt"

Check the help on the Format() function to determine the date/time format string you need.

HTH
Thomas