Re: OT: VB Assistance please Jim :-)

Schoolhouse rock comes to mind:

"Conjunction junction, what's your function?"

Did you try an "and?"

----- Original Message ----- 
From: "William Robertson" <robertson.william@xxxxxxxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Friday, July 09, 2004 9:28 AM
Subject: [isalist] OT: VB Assistance please Jim :-)


> http://www.ISAserver.org
>
> Hi Jim
>
> Apologies for intruding on the list for your reply, but I'm dead sure many
> people may find your reply useful, being the VB boff that you are ;-)
>
> I have a VB Script in which I am trying to locate all files on a server
that
> have been modified since a certain time and date. The crux of my query is
as
> follows:
>
> strQuery="Select Name,LastModified,FileSize FROM CIM_DATAFILE WHERE
> Drive='c:'"
>
> What I would love to do is include the following "where" clause to find
> files modified since 09 July 2004 at 10:00:00am:
> " where Left(LastModified,10) > 20040907100000"
>
> Obviously the above doesn't work though, so I was wondering if you might
be
> able to shed some light on the matter for me?
>
> TIA
> William R.
>
>
> ---------------------------------------------------------------------
> Everything in this e-mail and attachments relating to the official
> business of Columbus Stainless is proprietary to the company. It is
> confidential, legally privileged and protected by law. Columbus
> Stainless does not own and endorse any other content. Views and
> opinions are those of the sender unless clearly stated as being that
> of Columbus Stainless. The person addressed in the e-mail is the sole
> authorised recipient.  Please notify the sender immediately if it has
> unintentionally reached you and do not read, disclose or use the
> content in any way. Whilst all reasonable steps are taken to ensure
> the accuracy and integrity of information and data transmitted
> electronically and to preserve the confidentiality thereof, no
> liability or responsibility whatsoever is accepted if information or
> data is,for whatever reason, corrupted or does not reach its intended
> destination.
> ---------------------------------------------------------------------
>
> ------------------------------------------------------
> List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
> ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
> ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
> ------------------------------------------------------
> Other Internet Software Marketing Sites:
> World of Windows Networking: http://www.windowsnetworking.com
> Leading Network Software Directory: http://www.serverfiles.com
> No.1 Exchange Server Resource Site: http://www.msexchange.org
> Windows Security Resource Site: http://www.windowsecurity.com/
> Network Security Library: http://www.secinf.net/
> Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
> ------------------------------------------------------
> You are currently subscribed to this ISAserver.org Discussion List as:
thor@xxxxxxxxxxxxxxx
> To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
>



Other related posts: