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.
Discuss This Question: 1  Reply
Are you sure you have run a test where all of the dates' month are equal to @Datebeg?