As I said, Dave's solution is better.

Regards,
Fred

"Ian" wrote in message
...
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?


.