Finding the same set on a different day

[Roger1]

HI.

I have a DBase with 90,000 records with another 2,000 imported every fortnight.

I need to find the same set of records every fortnight the only difference being that they are for the current fortnight's date.

I can record a multiple find, but that doesnt help me get the current fortnight only.

I'd like to be able to click a button and have a field pop up that askes which date I am after.... is this possible?

[QuinTech]

Hi, Roger. Before your next import, you should create a field called ImportDate, a date field set to auto-enter creation date. When you do the import, make sure you have selected the option to "Perform auto-enter options while importing." Include this in your next find request, and i think you'll have what you're looking for.

HTH.

Jerry

[Roger1]

Thanks, I'll give it a try

[Roger1]

Thanks for the creation date idea, I see what that does and it will be useful for other things, but I failed to mention that the import already has an identifiable date.

More clearly I have a DBase with 90,000 records with another 2,000 imported every fortnight. Records come in with Date, Name, and amount.

I need to find the same set of records every fortnight (by client name) the only difference being that they are for the current fortnight's date and not last fortnights'.

Every F/n I do the same manual multiple search on about 50 names, for the current fortnight

I'd like to be able to (for example) record the search, click a button and have it ask me for the date that I want to search.

Is this possible?

Thanks for your help

Roger

[-Queue-]

Enter the desired date in a global date field while in Browse Mode. I'm assuming this would be for the oldest date you want. Then

Enter Find Mode [ ]

Go to Layout [one containing the date field on which to search]

Insert Calculated Result [datefield, DateToText(globaldate) & "..." & DateToText(Status(CurrentDate))]

Perform Find [ ]

This will find all records from the entered date to the current date.

[Roger1]

Thanks I'll give it a try