Condition problem

[#1]

Hi,

I need tu build condition sth like MonthYear is lower than Apr-2010. The formula:

Num(MonthYear)<num( 'Apr-' & LastSalesYear)

LastSalesYear is variable.

does not work. Can somebody help me?

[Anonymous]

Can't tell without knowing the format of your MonthYear field. And, the part on the right is not numeric in any case.
I would do it in a different way:
date < makedate(year(today())-1,4)
that is, date < April 1, 2009, if today is year 2010.