Solving a simple if..then statement

[Jordan Kidd]

I have quite a long program which is running, but I am trying to add one seemingly trivial section. I am not getting the right results, and I think it is something to do with the way in which I am setting up my if...then statement. I am novel to VBA, so I'm probably missing something simple. I'll post the code here.

Please Login or Register  to view this content.

sMoveIn and sRBeginDate are dates, but they are dim'ed as strings. Is that a problem? Is there a way to declare a variable as a date?

[Andrew-R]

Yes, you can dim a variables as a date:

Please Login or Register  to view this content.

It might help here, as doing a numeric > comparison against a string value (as you are in your nested If statement) is inviting unexpected results.