View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Strange Condition on Date Value

Hi all

Am using Excel 2010 Macro

I had this condition which strangely holds TRUE for these values
below:

CONDITION:
ElseIf Range("F" & z).Value Range("Q3").Value Then

VALUES
Range("F" & z).Value = 06-Jan-2015
Range("Q3").Value = 28-Feb-2015


This condition keep holding TRUE for the values. Is it not
recognizing them as date values? If so, how do I force the condition
to recognize them as date and thereby hold FALSE as expected.


My v2010 returns 'False' for this!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion