search in a date range?

[jeffer]

Hi all,

Maybe this is a straight forward question...but I just can't find the solution to my problem:(

I have a possibility to search invoices by date range. So when a customer wants to search for invoices that are created between 8/6/2003 and 15/6/2003 he should get al list of all the invoices that are created between these dates. But how do I need to script the search? I know when searching manual, you just add "..." between the two dates. But when the scripts sets the field I get a "?" in the search field.

Does anyone know how to solve this?

thnx allready and greetz,

jeffer

[-Queue-]

Go to Layout(layout with date field on it)

Insert Calculated Result[dfield, gfield1 & "..." & gfield2]

Set Field doesn't work because the result of the calculation is not a date.

The Insert will, though, as long as the current layout contains dfield.

[jeffer]

Hi -Queue-,

thnx for your reaction...but the database gives an error that the date, that is put into the date field with the "insert calc" function, isn't a right format. Is there any onther solution?

greetz,

Jeffer

[-Queue-]

My bad! You need to surround both global fields with DateToText() or else it searches by FileMaker's internal date, which is a number.

Sorry for the misleading information.

[jeffer]

ah...cool...now it works:)

Thnx for the support!

greetz,

Jeffer