Passing Datetime stamp to file name

[tgleghorn58]

I am using a savedexport in a macro. how do I pass a datetime stamp to the file name.

I created the savedexport because I want a pipe delimited txt file.

 

[tgleghorn58]

then I need to pass the filename to be a variable in a second file.

 

[Minty]

You can't use a true DateTime stamp as it will contain illegal characters. You would need to use something like Format("yyyy_mm_dd_hhnn",Date() ) .
I'm not sure how this would apply in a macro as I don't use them but it might help.

 

[RogerCooper]

You can't use a true DateTime stamp as it will contain illegal characters. You would need to use something like Format("yyyy_mm_dd_hhnn",Date() ) .
I'm not sure how this would apply in a macro as I don't use them but it might help.

You would use the ImportExportText command. The filename can be variable.