Name Function with DateAdd

[mrfritz44]

I want to name a file with the yesterday's date. Here's what I've got, but it's giving me an error:

Name "C:\Program Files\OCEAPC Software\oceDatedOutput\Oce.log" As "C:\Program Files\OCEAPC Software\oceDatedOutput\" & DateAdd("d", -1, Date$)& "_" & Format(Time, "hhnn") & "Oce.log"

Any idea what the corretc syntax is?

 

[PHV]

Probably invalid character(s) for file name.
You may try something like this:
As "C:\Program Files\OCEAPC Software\oceDatedOutput\" & Format(Now-1,"yyyy-mm-dd_hhnn") & "Oce.log"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mrfritz44]

Worked....thanks!