jwallace Posted January 3, 2001 Posted January 3, 2001 Need help resolving this: I have a DB that allows clients to assign dates to records. When those dates have arrived FM does a search for records whose dates are valid and displays the items. It works like a To Do list. Problem is this: Clients need to be notified daily of birthdays. Birthdays are in the past. So a simple Status (Current Date) match does me no good, but I need to be able to find birthdays that are today and any days that have not yet been checked. (If my clients do not run Filemaker for a few days, they need to be notified of all birthdays that have happened since the last time they were notified.) Another trouble area for me is the fact that if they run FM on december 22 and then not again until january 5, then simply making the year field not matter for the search doesn't work. The dates from december 22 to the end of the yer are never listed because the computer doesn't "know" to list them. Does this make sense? Any help?
BobWeaver Posted January 3, 2001 Posted January 3, 2001 I'm thinking there is likely an easier way considering how Filemaker handles the rollover of years and dates etc., but the following will work. Fields -------- LastRunDate - global date: the date that the program was last run TodaysDate -- global date: Today's date Birthday -- Date: Employees birthday BDay1 -- Date Calculation = Date(Month(Birthday),Day(Birthday),Year(LastRunDate)) BDay2 -- Date Calculation = Date(Month(Birthday),Day(Birthday),Year(TodaysDate)) Flag -- Number Calculation = Case( (LastRunDate<=BDay1)and(BDay1<=TodaysDate),1, (LastRunDate<=BDay2)and(BDay2<=TodaysDate),1,0) Flag will be 1 for all dates in the required range, and 0 for all others. So, do a find for Flag=1. [This message has been edited by BobWeaver (edited January 03, 2001).]
Recommended Posts
This topic is 8977 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now