Need help converting time and date stamp to vbscript now format for datediff comparison

I have an Antivirus program that sets a registry key with a time and date stamp in this format:
01-10-2008 00-31-41 which is:
DD-MM-YYYY HH-MM-SS

I want to use the vbscript function datediff to compare that with the now() time so I can figure out if how old my AV databases are and how long ago the last full scan was ran.

I don't think the time format above is a standard format.  Please provide a code sample that will help me with the datediff.

Thank you!
jamie177Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sirbountyConnect With a Mentor Commented:
as an example...
strDate = "01-10-2008 00-31-41"
arrData = split(strDate, "-")
dd=arrData(0)
mm=arrData(1)
yy=Left(arrData(2),4)
hh=Right(arrData(2),2)
nn=arrData(3)
ss=arrData(4)
 
newDate=cDate(mm & "/" & dd & "/" & yy & " " & hh & ":" & nn & ":" & ss)
 
wscript.echo newDate
wscript.echo dateDiff("d",newDate,now)

Open in new window

0
 
jindalankushCommented:
i think,
u hv to cast date in ur required  formate ,then use datediff function
0
 
danaseamanCommented:
You can also use DateSerial+TimeSerial to build VbDate.
This way makes it internationally aware.

Private Sub Form_Load()
   Dim strDate
   Dim arrData
 
   strDate = "01-10-2008 00-31-41"
   arrData = Split(Replace(strDate, " ", "-"), "-")
 
   newDate = DateSerial(arrData(0), arrData(1), arrData(2)) + TimeSerial(arrData(3), arrData(4), arrData(5))
 
   wscript.echo newDate
   wscript.echo DateDiff("d", newDate, Now)
End Sub

Open in new window

0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
danaseamanCommented:
Correction.
   strDate = "01-10-2008 00-31-41"
   arrData = Split(Replace(strDate, " ", "-"), "-")
 
   newDate = DateSerial(arrData(2), arrData(1), arrData(0)) + TimeSerial(arrData(3), arrData(4), arrData(5))
 
   wscript.echo newDate
   wscript.echo DateDiff("d", newDate, Now)

Open in new window

0
 
jamie177Author Commented:
Thanks gents, I'm going to work on this and see what works for me and will close up the questions soon.

-Jamie177
0
 
jamie177Author Commented:
Thank you sirbounty!  Perfect, just what I was looking for!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.