AnsweredAssumed Answered

Count records based on date criteria

Question asked by BruceWyrwitzke on Mar 3, 2011
Latest reply on Mar 4, 2011 by BruceWyrwitzke


Count records based on date criteria


Sorry for sounding like a moron - trying to make the transition from MS Access to FMP and it's been a slow process...

I have a contact management database that stores basic contact info in one table and key dates in another.  My goal is to have a start page/layout that lists events for the next 7 days that I can click on and then open a layout with just those records.  Here's a simple example of what I would like on the "main page" when the databse opens:

"There are XX birthdays in the next 7 days."

I've tried setting a global variable in the key_dates table based on a calculation using

count(month(Birthday) = month(Get(CurrentDate)) and day(Birthday) = day(Get(CurrentDate))

but I keep getting errors.  Any help would be greatly appreciated.  Thanks.