I am working in Dbase and need a solution for finding a record in a database that is indexed on a date field within the database. The database tracks changes to the valuation of a given piece of equipment. Changes to the valuation may or may not occur on a consistent basis. I need to search the database and a return the corresponding valuation that was in effect on that date. The date may or may not be an exact match and the index is on the dates of that the value changed. What code can I use to simplify finding the value that was in existence on a day that there isn't a corresponding match to a date within the database as the FIND command will not find the record? All help is appreciated, thanks
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.