I tried that before sending this and that did not work either. I just tried it again and all I get is nulls.
jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Saturday, February 06, 2010 3:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: year comparisons in repor << vYear = (IYR(Quotedate)) vQ2009 = (IFEQ(.vYear,2009,Quotesubtotal,0)) vQ2010 = (IFEQ(.vYear,2010,Quotesubtotal,0)) >> You must use the function IYR4 to get four-digit years. The (older) IYR function returns only two digits, so you're getting values of "9" and "10" which don't match 2009 and 2010. -- Larry
