Hi,

I typically maintain history information with fields like:

StartDate
EndDate
...values...

When locating a record for a specific date, i can easily use Between( DateBeingSearchedFor, StartDate, EndDate ) in a LOCATE or SELECT statement.


Now i'm trying to think if i can easily just store the StartDate, i.e.,

StartDate
...values...

But i'm not coming up w/a quick and easy way to locate an entry for DateBeingSearchedFor.

Any ideas? other than just doing a scan of the table?

TIA, Jill