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.