Auto entering greater than

[Esmo2000]

Hi everyone,

I'm in need of auto entering a greater than or equal symbol in Filemaker. I need it to constrain all the results to a date range. Unfortunately, the date range is calculated by another field. Subsequently, I need to have it do something like inserting a calculation along the lines of

">=" & Field 1 & " <=" Field 2

Suggestions?

Thanks!

-Jim

[-Queue-]

If you're using a version less than 7, Insert Calculated Result [datefield, DateToText(Field1) & "..." & DateToText(Field2)]. Note that datefield must be on the current layout.

If using 7, Set Field [datefield, Field1 & "..." & Field2]. datefield need not be on the current layout.

[Esmo2000]

Thanks, it works beautifully!

Sincere regards,

Jim