Script to find records in Date range

[Treigh]

Hi guys,

I have two scripts written to find records contained in a date range and display the found records in a report layout.

To accomplish this, two global storage fields are used: Find_StartDate and Find_EndDate to temporarely store the start and the end dates. Another date field ClockIn_Date uses the dates stored in the global fields as a search criteria.

My first script:

New Window [Name:"SEARCH TIMESHEET"; Height:335; Width:367; Top:25; Left:25]

Show/Hide Status Area [Hide]

Go to Layout ["TIMESHEET - SEARCH" (TRANSACTIONS)]

Enter Browse Mode []

My second script:

If [isEmpty ( TRANSACTIONS::Find_StartDate)]

Show Custom Dialog ["Start Date";"Start Date must have a value. Please reenter"]

Exit Script []

End If

If [isEmpty (TRANSACTIONS::Find_EndDate)]

Show Custom Dialog ["End Date";"End Date must have a value. Please reenter"]

Exit Script []

End If

If [TRANSACTIONS::Find_EndDate < TRANSACTIONS::Find_StartDate]

Show Custom Dialog ["End Start";"End Date cannot occur before Start Date. Please reenter"]

Exit Script []

End If

New Window [Name:"SEARCH RESULTS"; Height:742; Width:850; Top:25; Left:25]

Go to Layout ["TIMESHEET - FIND" (TRANSACTIONS)]

Enter Find Mode []

Insert Calculated Result [select;TRANSACTIONS::ClockIn_Date;TRANSACTIONS::Find_StartDate & "..." & TRANSACTIONS::Find_EndDate]

Perform Find []

Go to Layout ["PUNCHCARD - WEEKLY REPORT" (TRANSACTIONS)]

When the scripts are executed, I don't get passed passed the first layout. (first script).

Any help will be appreciated.

[Matthew F]

Do you mean that the New Window is never generated by the second script? What triggers the script?