Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.