File name date (1 Viewer)

[kitty77]

DoCmd.OutputTo acOutputReport, , acFormatPDF, "\\SERVER\Billing\" & [Mdid] & ".pdf"

How can I make the above include the date as part of the file name?

 

[Ranman256]

= "\\SERVER\Billing\" & [Mdid] & format(date(),"yymmdd") & ".pdf"

 

[cheekybuddha]

  Dim filename As String
  Const FILEPATH As String = "\\SERVER\Billing\"
 
  filename = FILEPATH & Format(Date, "yyyymmdd") & "_" & [Mdid] & ".pdf"
  ' or
  filename = FILEPATH & [Mdid] & "_" & Format(Date, "yyyymmdd") & ".pdf"
  Debug.Print filename
 
  DoCmd.OutputTo acOutputReport, , acFormatPDF, filename