Scripting a "Find by Date Range"

[picnichouse]

Hi,

One of the most frustrating aspects of Filemaker for me is that you can't insert a variable or field in a "Perform Find" script step... i.e. you can't

"Find by a date before Field1 and after Field2."

I'd like to allow my users to enter a start date and end date in global fields and find records with a CreationDate field in that range when clicking on a button. What's the best way to do this?

Thanks!

[SlimJim]

Use a range find: insert startdate &"..."& end date into the CreationDate field.

[RalphL]

Assuming Field 1 (gDate1) is after Field 2 (gDate2)

Enter Find Mode

Set Field [CreationDate, GetAsText (gDate2) & "..." & GetAsText (gDate1)]

Perform Find

[LaRetta]

Enter Find Mode [ ]

Set Field [ CreationDate ; gStart & "..." & gEnd ]

Perform Find [ ]

[LaRetta]

And who says Forums doesn't rock in providing instant service? :bigshades:

[SlimJim]

OK you slow-coaches Ralph and LaRetta - what were you waiting for.

[LaRetta]

We were waiting for you to point the way, of course!

BTW, I don't believe GetAsText() is required. And I use global date fields. In this way, FM will validate that the date is correct when Users type into the globals. Your finds will then more consistently produce the desired results.

You may also want to test that both fields contain a date. You would change the script to:

If [ gStart and gEnd ]

Enter Find Mode [ ]

Set Field [ CreationDate ; gStart & "..." & gEnd ]

Perform Find [ ]

Else

Show Custom Dialog [ Message: "OK" ; "You didn't enter both dates. Try again." ]

Exit Script

End If

[RalphL]

Somebody had to be first!

[picnichouse]

jeez

thanks!

...