only works if it's the same year?

what if the dates are Dec 31, 2008 and Jan 1, 2009?



"Roger Govier" wrote:

Hi Ian

=if(Month(readdate)<month(startdate),"yes","no")
--
Regards
Roger Govier

Ian wrote:
I have two date colums
StartDate
ReadDate

I want to find all the readdates that are in months prior to the startdate

Eg if(readdate<startdate,"yes","no")

the problem is that if the readdate is in the same month (or any later date)
as the startdate I want a "no' returned. Is there any way to compare to
dates in a mm/yyyy format?


.