[dba-Tech] Today's files

John R Bartow jbartow at winhaven.net
Mon Jun 1 11:14:00 CDT 2015


Hi Mike,
That's nice.

I was wondering if this could be done using Windows Explorer compression
(zip) utility.

John B

-----Original Message-----
From: dba-Tech [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
Tope Mike
Sent: Monday, June 01, 2015 8:57 AM
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] Today's files

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.

_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com




More information about the dba-Tech mailing list