is it possible to write a script that will note what today's date is, then find all records within a month of today's date? I have only been able to do this if I input a specific date into the script, but I want it to work from whatever date is today. I need it to show all records a month from the day i access the file.

Thanks!

Your script should look like this:

Enter Find Mode

Insert Text [YourDateField, ">="][select entire contents]

Insert Calculated Result [YourDateField, Today-30]

Perform Find

Note, the proper "greater than or equal to" symbol which doesn't display properly here should be substituted for ">="

You must use the Insert command rather than the Set Field command when entering a date range into a date field.

[This message has been edited by BobWeaver (edited March 06, 2001).]

I used the following script successfully:

Enter Find Mode[ ]

Insert Calculated Result [select, "DateField", "DateToText(Today)& "..." & DateToText(Today+30)"

Perform Find [ ]

Ignore the calculation instruction that the result must be a date. Entering a text string into the date field works for the find.

Oh right! TyGuy assumed 30 days in the future, and I assumed 30 days in the past. Oh well, you can take your pick.

Can I suggest that Status(CurrentDate) be used instead of Today function. Today is only calculated when the db is first launched, so it breaks if the file is left open for more than 24 hours.

Thanks for all your help!

Much appreciated.