Date Range Relationship v6

[Jake Sterling]

I am doing a job for a company that is locked into FMP v6. I have to make a relationship to records within a range of dates. I have done this by setting up a text field (tFindDate) and then running a script that Replaces the data in that field with 1 or 0 depending of whether the record is within the date range or not. The Replace formula looks like this:

If ( Date > BeginDate and Date < EndDate, 1, 0 )

(Those signs are supposed to be "greater than or equal to" and "less than or equal to" signs, but those aren't part of basic ASCII so I can't use them)

To call up all the related records within that range, I have a global link field that contains the number 1. (There are actually two other, non-date parameters involved. But let's keep it simple)

Does anyone have a method to do this sort of thing that doesn't involve going through all the records in the other file and identifying them? It works that way, but it is really slow and also a bit confusing to anybody else who has to work on your database later. By the way, I do know that FileMaker v7 is able to create relationships based on a date range; but, unfortunately, the company I am working for is stuck in v6 for the time being, so I am, too.

Thanks, Jake

[QuinTech]

a bit confusing to anybody else who has to work on your database later

If you thought that was confusing...

Look into Mikhail Edoshin's smart ranges technique. It's a tricky one, but it works. Read up on it and search these forums for +Edoshin +smart +ranges and follow up with any specific questions.

J