Oh, yeah.the old memory is failing again. Thanks!
From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Chad Novotny Sent: Thursday, January 08, 2009 11:57 AM To: [email protected] Subject: Re: Find argument You need to treat the whole thing as a concatenated text string: gFromDate & "..." & gThruDate Regards, Chad On Jan 8, 2009, at 11:46 AM, Ron wrote: I am trying to set a range of dates for a Find, in a script which runs a report.. It uses values from a table containing various globals, related by key (an "X") to the table the report is based on. Set Field [Donation::DateReceived], Donation_HoldVariables::gFromDate...Donation_HoldVariables::gThruDate I get "The specified field cannot be found". If I try GetAsDate(Donation_HoldVariables::gFromDate)...GetasDate(Donation_HoldVariab les::gThruDate) I Get "This number cannot be evaluated". gThruDate and gFromDate are Date data types, global. They are populated by a layout that does nothing but get the date values (or another value if user wants report that way: that doesn't work either, but it just doesn't do the Find!). Whole script: Go to Layout [ "DonationDetailReport" (Donation) ] Show All Records Enter Find Mode [ ] [ Pause ] Set Field [ Donation::DateReceived ] Perform Find [ ] Sort Records [ Specified Sort Order: Donation::Campaign; ascending Donation_PersonInHousehold::LastName; ascending Donation_PersonInHousehold::FirstName; ascending ] [ Restore; No dialog ] Enter Preview Mode [ Pause ] Enter Browse Mode Go to Layout [ original layout ] January Ron Carr *************** Chad Novotny Vice President - Technology The Support Group, Inc. database design, development and training services boston - los angeles - new york - san francisco 24 Prime Park Way Natick, MA 01760 t: 508.653.8400 x217 f: 508.653.2830 [email protected] www.supportgroup.com
