Query by period of date from 2 table

[Charlih Chen]

Hello ALL:

I have a fm7 called [color:blue]IT asset inventory.fm7

There is layer called Inventory transfered report.

On the layer, I like to have a Query to input as From Date1: [ ] to Date2: [ ]

The period of date will check and match the field called Check out Date from the two fm7 files called [color:blue]PC.fm7 and [color:blue]Peripheral.fm7.

(Note: The Check out Date is meaning that either PC or Peripheral was checked by employee)

Question:

Is it possible to display the result within Protal on the same layer: Inventory transfered report?

[Charlih Chen]

Here is a Script called the Query by Date Range.

================================================

Show All Records

Show Custom Dialog [ Title: "Search between two Dates"; Message: "Use the format yyyy/mm/dd i.e. 2006/07/31"; Buttons: "OK",

"Cancel"; Input #1: Asset Management::Date From; Input #2: Asset Management::Date To ]

Enter Find Mode [ Specified Find Requests: Find Records ]

[ Restore ]

Set Field [ Asset Management::Date Check Out; Asset Management::Date From & "..." & Asset Management::Date To ]

Set Field [ Peripheral Management::Date Check Out; Asset Management::Date From & "..." & Asset Management::Date To ]

Perform Find [ Specified Find Requests: Find Records; Criteria: Asset Management::Date Check Out: "7/1/2006...7/31/2006" ]

[ Restore ]

==================================================

Question: There are two Set Field for Date, how to change the "AND" into "OR" for the FIND mode?