Compare dates using VB Script

I'm not sure what I'm doing wrong here so maybe you can help.

I have two variables. Both hold dates.  One is today's date and the other date is passed via a form.

      strTodaysDate = Date()
      strMoveInDate = TRIM(CDATE(Request.Form("moveInDate")))

Now I have a script like this:

      If strMoveInDate < strTodaysDate  THEN
            strErrorMessage = strErrorMessage +  "- The Move-In date can not be less than today's date <br />"
            strErrorCount = 1  
      End If

Here's the problem.  If the passed date is 10/30/2011 the If then doesn't seam to work.  The strErrorCount doesn't = 1.  What am I doing wrong?
cdemott33Asked:
Who is Participating?
 
Bill PrewCommented:
Get rid of the TRIM.  I suspect that is resulting in a string variable type, rather than the desired date type.

strMoveInDate = CDATE(Request.Form("moveInDate"))

Open in new window

~bp
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
you may also want to use the DateDiff function which would be a safer way (safer meaning less chance for an error to occur) to compare dates:

http://www.w3schools.com/vbscript/func_datediff.asp
0
 
cdemott33Author Commented:
That was it.  I still needed to do the TRIM but I did it this way...

      strMoveInDate = TRIM(Request.Form("moveInDate"))
      strMoveInDate = CDATE(strMoveInDate)

Thanks for your help.
0
 
Bill PrewCommented:
Thnaks, glad that helped.  You should be able to do this as well.

      strMoveInDate = CDATE(TRIM(Request.Form("moveInDate")))

~bp
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.