Searching for a period of days

[Dean Redding]

Hi,

Could anyone help me on how I can do the following:

I created a party planning database where I have active bookings and completed bookings.

I have a field called "Job Status"

and a field called "Date of Function"

What I want is to compile a find / report of all the "Active" bookings in the job status field for any bookings that are within the next 60 days.

I can perform a date range find, but I have to keep entering the dates.

I want something a little more automatically, so I can press a script button and will it do it all for me.

In Microsoft access, I was able to do it, but now on Filemaker I cannot.

What I did in Microsoft was a formula called

"<()+60"

which meant - Any bookings that are in the next 60 days of todays date.

Let me know if someone can help.

Thank you,

Dean

[Genx]

Script is...

Enter Find Mode[]

Set Field[Job Status ; "Active"]

Set Field[Date of Function ; Get(CurrentDate) & "..." & Get(CurrentDate) + 60]

Perform Find[]

[Dean Redding]

Thank You!.

Much appreciated.

[Genx]

:P No Problem