Posted to microsoft.public.excel.programming

nbs

external usenet poster

Posts: 7

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF(AND with date comparison	PSU35	Excel Worksheet Functions	4	October 27th 09 03:14 PM
Date Comparison	Vic	Excel Discussion (Misc queries)	1	October 22nd 09 03:18 PM
Date comparison	adimar	Excel Worksheet Functions	14	February 3rd 08 06:44 PM
Date comparison	TomD	Excel Discussion (Misc queries)	4	February 20th 07 10:37 PM
Date comparison	Darkdrew	Excel Worksheet Functions	7	March 23rd 06 04:22 PM

All times are GMT +1. The time now is 08:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us