I have seven dates on my crystal report.I need to compare month of each date with the date the report is made to run(@Datebeg is the field for report date). I am using formula on my report as:

if month({Date1})=month(cdate({@Datebeg})) and 
month({Date2})=month(cdate({@Datebeg})) and 
month({Date3})=month(cdate({@Datebeg})) and 
month({Date4})=month(cdate({@Datebeg})) and 
month({Date5})=month(cdate({@Datebeg})) and 
month({Date6})=month(cdate({@Datebeg})) and
month({Date7})=month(cdate({@Datebeg}))
then (H1+H2+H3+H4+H5+H6+H7) else 1.

The output I am getting is 1,each time.The months are not getting compared at all.If I put OR instead of AND,that gives me sum of all H(1..7). Please help me with the comparison. Thanks in advance.