Get previous days date in MMDDYY format

[Steel811]

Hello,

Does someone know how to get the previous day's date in MMDDYY format? I am writing a script that will move an IIS log from one server to another so my web analytics product can analyze the log. Our logs rotate at midnight, at midnight tonight, our logs will rotate and the new log will be called EX081125.log. I would then run a script to copy the EX081124.log log file over to my web analytics server. Any help would be greatly appreciated!

Thanks,
Sheel

 

[PHV]

A starting point:
MsgBox "EX" & Right(Year(Date-1),2) & Right("0" & Month(Date-1),2) & Right("0" & Day(Date-1),2) & ".log"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886