saving a report as SNP

[NNlogistics]

DoCmd.OutputTo acOutputReport, stDocName, "snapshot format", "OpenRMAAging" &
Date & ".snp"

I am Atempting to save a reprt as a .snp file an what I would like to do is
save it with todays date. It works, however, it puts the slashes in and that
doesnt play well with windows. How can I use the date to stamp the file.

also

If I use the full path \\servername\dira\dirb\"OpenRMAAging" & Datein
correct format & ".snp", will it just write it to that directory?

 

[Rick Brandt]

DoCmd.OutputTo acOutputReport, stDocName, "snapshot format",
"OpenRMAAging" & Date & ".snp"

I am Atempting to save a reprt as a .snp file an what I would like to
do is save it with todays date. It works, however, it puts the
slashes in and that doesnt play well with windows. How can I use the
date to stamp the file.

also

If I use the full path \\servername\dira\dirb\"OpenRMAAging" & Datein
correct format & ".snp", will it just write it to that directory?

DoCmd.OutputTo acOutputReport, stDocName, "snapshot format", "OpenRMAAging"
& Format(Date,"yyyy-mm-dd") & ".snp"

 

[NNlogistics]

Any ideas on saving in a specific directory?

 

[Rick Brandt]

Any ideas on saving in a specific directory?

Just put the path to the folder in front of the file name.