Interval search

#1

Hi

I currently use the following search criteria in FileMaker 7: Get
(CurrentDate) - 30 & "..." & Get (CurrentDate)

Instead of this criteria I would like to make an interval search, where the
user is prompted to enter the start and end date of the interval.

Does anybody know how that can be done?

Thanks

Daniel

#2

Create 2 global date fields 'DateFrom' and 'DateTo' and put them in a
layout such that the user will have to enter dates. The formula becomes
: Interval = DateTo - DateFrom
Remi-Noel

"D" <d (AT) msn (DOT) com> a écrit dans le message de news:
431eba2e$0$172$edfadb0f (AT) dread11 (DOT) news.tele.dk...

Quote:

Hi

I currently use the following search criteria in FileMaker 7: Get
(CurrentDate) - 30 & "..." & Get (CurrentDate)

Instead of this criteria I would like to make an interval search,
where the user is prompted to enter the start and end date of the
interval.

Does anybody know how that can be done?

Thanks

Daniel

#3

Quote:

On Wed, 7 Sep 2005 12:35:22 +0200, Remi-Noel Menegaux wrote:
Create 2 global date fields 'DateFrom' and 'DateTo' and put them in a
layout such that the user will have to enter dates. The formula becomes
: Interval = DateTo - DateFrom
Remi-Noel

I'd recommend instead to use DateTo and DateFrom as global fields,
applying the search as directly as

enter find mode
paste result (Date, DateFrom & "..." & DateTo)
perform find

- Martin

Thanks a lot for your fast help!

It worked out perfectly :-)

/Daniel

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Interval search

comp.databases.filemaker comp.databases.filemaker

Interval search - 09-07-2005 , 05:00 AM

Re: Interval search - 09-07-2005 , 05:35 AM

Re: Interval search - 09-07-2005 , 07:55 AM