HELP with using a Date as file name

  • Thread starter Thread starter JT
  • Start date Start date
J

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!
 
Aassuming that you want to add the current date:

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