Jump to content

Date Based Ticklers


This topic is 8543 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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).]

Link to comment
Share on other sites

This topic is 8543 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.