Find and constraining find by date

[CalMaverick]

I am on FM7 and trying to run a script that will find all records that show "confirmed" on any of 4 different services I offer. Then I want it to only show records from todays date going forward.

Right now I have the script

Perform Find

Sort by date

Go To Layout (where I have a report)

Can anyone tell me the script to constrain my find and show only confirmed events from todays date forward.

I think this should be simple. Any help would be a huge help.

THANKS FM FORUMS!

[mr_vodka]

You havent discussed your structure. Are you using 4 fields for the services, or are you using a related table? What table is the report layout based off of? We need mroe info.

[CalMaverick]

Thanks for the fast reply!

I'm using four different fields.

Fields are:

DJ Status

Video Status

Photo Status

Dance Floor Status

The report layout is based off of all the call log info.

In the end I am trying to click a button that runs this script the will find "confirmed" in any one of the four fields about. The show only the records from todays date forward. Then go to my report layout that will show all found records in order by date.

Does this help?

Thanks again!

[mr_vodka]

Well it helps but it is not 100% clear. I guess I will have to assume that these four fields are from the same call log table.

Enter Find mode []

Set field [ DJ Status; "confirmed" ]

Set field [ CallDate; ">=" & Get (CurrentDate) ]

New Record /Request

Set field [ Video Status; "confirmed" ]

Set field [ CallDate; ">=" & Get (CurrentDate) ]

New Record /Request

Set field [ Photo Status; "confirmed" ]

Set field [ CallDate; ">=" & Get (CurrentDate) ]

New Record /Request

Set field [ Dance Floor Status; "confirmed" ]

Set field [ CallDate; ">=" & Get (CurrentDate) ]

Perform Find []

Sort by CallDate

Go To Layout [ReportLayout]

[CalMaverick]

Thanks, this has me going in the right direction.

Can you tell me what is wrong with this calculation?

[ confirmedby::Event date ">=" (confirmedby::todays date) ]

this is really where I struggle. Understanding how the calculation language works. Any suggestions on where I can learn this lingo?

I appreciate the help!

[mr_vodka]

I am not sure if this is the context of a set field step or what.

But if taking just what you have here as a straight calc, you have nothing that connects text string and the date fields. You need a ' & ' to concatenate fields and the text.