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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill PrewIT / Software Engineering ConsultantCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big MontyWeb Ninja at largeCommented:
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 PrewIT / Software Engineering ConsultantCommented:
Thnaks, glad that helped.  You should be able to do this as well.

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

~bp
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.