Re: OT: VB Assistance please Jim :-)

  • From: "Thor" <thor@xxxxxxxxxxxxxxx>
  • To: "[ Discussion List]" <isalist@xxxxxxxxxxxxx>
  • Date: Fri, 9 Jul 2004 09:31:47 -0700

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: "[ Discussion List]" <isalist@xxxxxxxxxxxxx>
Sent: Friday, July 09, 2004 9:28 AM
Subject: [isalist] OT: VB Assistance please Jim :-)

> 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
> have been modified since a certain time and date. The crux of my query is
> 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
> able to shed some light on the matter for me?
> 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:
> ISA Server Newsletter:
> ISA Server FAQ:
> ------------------------------------------------------
> Other Internet Software Marketing Sites:
> World of Windows Networking:
> Leading Network Software Directory:
> No.1 Exchange Server Resource Site:
> Windows Security Resource Site:
> Network Security Library:
> Windows 2000/NT Fax Solutions:
> ------------------------------------------------------
> You are currently subscribed to this Discussion List as:
> To unsubscribe visit

Other related posts: