Jump to content

Query by period of date from 2 table


This topic is 5593 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

  • 2 weeks later...

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?

Link to comment
Share on other sites

This topic is 5593 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.