[dba-Tech] Today's files

[Tope Mike]

Vbscript gives us date arithmetic. This is just two lines, run it in a DOS box with cscript scriptname.vbs:-

Set objShell = Wscript.CreateObject("Wscript.Shell")
objShell.run "cmd /k forfiles /s /d " & dateadd("d",-1,date()) & " /c ""cmd /c if @isdir==FALSE 0x22%ProgramFiles%\Winzip\Winzip32.exe0x22 -a lastday.zip @file"""

regards
Mike

-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: 01 June 2015 12:48
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] Today's files

Thanks, Mike.

On Mon, Jun 1, 2015 at 7:24 AM, Tope Mike <Mike.Tope at saipem.com> wrote:

> In windows:-
> Forfiles takes a date argument
> Or maybe xcopy /d /s /l
>
> regards
> Mike Tope
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com
******************************************************************************************
CONFIDENTIALITY NOTICE
This e-mail and any attachment are confidential and may be privileged or otherwise protected from disclosure. It is solely intended for the person(s) named above. If you are not the intended recipient, any reading, use, disclosure, copying or distribution of all or parts of this e-mail or associated attachments is strictly prohibited. If you are not an intended recipient, please notify the sender immediately by replying to this message or by telephone and delete this e-mail and any attachments permanently from your system.