ATTN Visual Basic Programmers

[adamthole]

I'm having a problem with a program I am writing. It is a Video Renting program, and to calculate Late Fees I have something similar to:

Late = (frmvhsout.txtFields(2) <= Date)

That will return a true or false value. But, when frmvhsout.txtFields(2) is equal to a date older than today's Date or today's date, it gives me a false value.

I can only assume that I am using the Date function in an improper way.

Does anyone know how I could fix this? Or a better forum to post this in? Thanks.

[tekkieman]

It could be moved to the Programming forum .

Are you using VB or VB.NET?

[adamthole]

I didn't know there was a programming forum

I'm using just VB

[Capmaster]

Moving to the Programming forum

[tekkieman]

Ok, first, you should probably cast the textbox entry to the same datatype using CDate(frmvhsout.txtFields(2).Text). From there, you should be able to compare using Late =(CDate(frmvhsout.txtFields(2).Text)<= Now). My VB is on my test server, and I only have .NET on this machine, but that should work for you.

If not, let me know, and I'll fire up the other box.

[adamthole]

Thanks a lot! I've been trying at that for an hour or more.

It now works perfectly...or atleast that one line of code

[tekkieman]

No prob. Just give a yell if you get stuck.