Hi,

I am trying to use a script to perform a find on a number of records each with a creation date. In another Filemaker database i have two global fields (date) from and to, so i want to use these from and two fields to specify a date range in which to perform the find. i wanted to use:

Enter Find mode

Set Field (external::datefrom) & "..." & (external::dateto)

Perform Find

But i just get a ? in the creation date field.

Any Ideas?

enter find mode

paste calculated result, creation date, datetotext((external::datefrom) & "..." & datetotext(external::dateto)

perform find

Hello Dave,

I tried to reproduce your problem, but it all worked as expected. But when I changed the global fields from date to text I got exactly what you see...

Can you doublecheck if your global fields are indeed date-fields?

Regards,

Ernst.

Have a look at my sample file under the Handy Bits thread in the Samples section of this forum. It has numerous examples of date range calcs. Its down a few pages in normal view, but if you show the topics by number of views, it will be up near the top.

Thanks Everyone i have sussed it using the calculation instead, but it also fixed it changing global to date.

Dave