Creating a button that combines multiple searches

[Phil H.]

Hi Guys,

I run a Macintosh computer rental company and am trying to finally update my database. I would like to create a button or field that searches for all records that begin, end or have an action date (will be all differernt fields) for a specific date which I enter. In other words, I'd like to be able to enter today's date and view all of my computer rentals that either start today, end today, or have some sort of action flagged for today. Can this be done? And how?

Many thanks in advance...I'm quite desperate! :

-Phil

[Fitch]

Use a global field (e.g. gDate) and a script something like this:

Enter Find Mode []

Set Field [start date ; gDate]

New Record/Request

Set Field [end date ; gDate]

New Record/Request

Set Field [action date ; gDate]

Perform Find []

[Phil H.]

Thanks so much! I hate to be a pest, but what is gdate?

[Phil H.]

Ok, sorry. I figured out that that means global date...

But how do you do both as you showed? i.e.

[start date; gdate]

Thanks!

-Phil

[Phil H.]

Ok. Here's what I have so far that isn't working:

I want to have a Date Field I can enter a date into called "Search Date"

I would like to be able to enter a date value for this Search Date and have a script pull up all of the records for:

Commencement Date

End Date

Action Date

Can I do this?

[Robert Collins]

You could try putting a Custom Dialog command in front of what Fitch has already shown you- this would allow you to enter a date.The set Field "" command will make sure that the date entry box is empty every time you run the script

SetField [gdate} ; ""]

Show Custom Dialog ["Please enter search date]; Gdate]

[Phil H.]

"You could try putting a Custom Dialog command in front of what Fitch has already shown you- this would allow you to enter a date.The set Field "" command will make sure that the date entry box is empty every time you run the script

SetField [gdate} ; ""]

Show Custom Dialog ["Please enter search date]; Gdate]

"

Hi, thanks for the reply, but I'm too novice to understand what the semicolon and "" functions are and how to set them?

Thanks!

[Fitch]

FileMaker 6 uses commas instead of semicolons. I whipped up an example file for you, have fun.

DateFinder.zip

[Robert Collins]

I would attach an example file for you myself if if were not for the fact I only use FM9 and cannot seem to save a file in fM6 format :)

[Fitch]

By the way Phil, the pair of quotation marks in Robert's example is just a way of saying "blank" or "empty" or "clear this field."

[Phil H.]

Fitch & Robert,

I must sincerely thank the both of you. Your patience and willingness to help me out were pretty outstanding. I was able to get that search working and I'm very grateful!

What a great forum I've found here!

-Phil

[Robert Collins]

You are very welcome