Date Comparison in Code
Having a problem with a date comparison...
c1 = 9/21/04 9:00:00 AM
d1 = 9/15/04 11:00:00 AM
If date (c1) (d1) then UserForm1.Show
This should show the form, but instead because 11 is
greater than 9 it does not. And, when you reverse the
formula is will show the form.
If date (c1) < (d1) then UserForm1.Show
Is there a setting or reclaration required?
Thanks,
Noel
|