HELP with using a Date as file name

[JT]

Is ther a simple way to add a DATE as part of the file name when
exporting a text file?
I.E. ="C:\audit\data_name" & sysdate & ".txt"

Of course this did not work!

 

[Ken Snell]

Aassuming that you want to add the current date:

="C:\audit\data_name" & Format(Date(), "mm-dd-yyyy") & ".txt"

 

[JT]

Thanks very much, that worked exactly like I needed.