How do I use Date Functions for File Names in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create an OutPutTo Excel file using a date function to name
the output file. Basically I need to be able to name the output file using
the current date and time or use the current date with an incrementing number
for each file generated for that date.
 
Use an expression similar to this in the argument for the filename:

="C:\MyFolder\FileName" & Format(Date(), "mmddyyyy") & ".xls"
 
Back
Top