I have a database with a datefield. I need to find the records that have no date in the datefield (finding =) and those who contain a date after the date of today minus 8 days. So today is 04-05-2002, I need to find > 26-04-2002. It is necessary to perform this find in a script but whatever I tried it does not work. Does anyone have a solution ?

Bert

Often asked question. First, the date field must be on the current layout. Let's say your date is in a global date field called "gDate". This script might look like:

Set Field (gDate, Status(CurrentDate) - 8)

Enter Find Mode()

Insert Text (yourfield, ">")

Insert Calculated Result (yourfield, gDate)

Perform Find ()

Make sure the "select" option is off on the second insert or it will wipe of the first (">"). Also don't use the "Today" function, use Status(CurrentDate) instead.

-bd

Yes, this works fine, thanks a lot !

Bert