[DrewAllen]

Apparently Blackbaud has trouble with this question, because it thinks that 2/15/2002 is in the current fiscal year.

I'm working with the Donor Analytics datamart that BB did for us when we took the TIE training. I was working on a formula that uses the IsInCurrentFiscal and getting VERY strange results. I looked at the code that BB was using and found a bug. BB passes the gift date, the current date, and the month that the fiscal year starts to a function that is supposed to tell you whether the gift date falls within the current fiscal year. The problem is that BB uses the GIFT date rather than the current date to calculate the current fiscal year. Essentially the formula boils down to "Is the gift in a period that's parallel to FY to date?" Since we've passed 2/15 in the current fiscal year, 2/15/2002 is in a parallel period for fiscal year 2002.

The worst thing is that BB used two different user defined functions (which causes your data to be processed linearly rather than as a set) with a total of 3434 characters to produce the WRONG answer when I was able to produce the RIGHT answer with only 227 characters and no UDFs.

Drew