I know I've read a discussion on this here recently but can't find it.

How can I modify a script Find step so that it only includes records with today's date in a given field? I have a related db called CurrentDate with one record that is updated daily for same.

I have tried in the past to use the copy and paste steps but it has never worked for me. In evitably, it pastes the last copy I did in filemaker, not the new copy asked for by the script.

Bob:

In Find mode, instead of pasting, you can use Set Field, and set it to Status(CurrentDate)

-Stanley

No, as a matter of fact you cannot do that. Did you try it?

Unfortunately you cannot use set field on date fields in Find mode. You must insert calculated result or paste. Or you can use the Filemaker today's date symbol, // and store/restore the find request.

Bruce:

It works for me. FM 5.5 on Mac OSX

-Stanley

"No, as a matter of fact you cannot do that. Did you try it?"

Really?

If it can't be done please explain why the script below works on all Macs and Pc's where I work.

Enter Find Mode[]

Set Field["Test Date","Status(Current Date)"]

Perform Find[Replace Found set]

Did you try it? Or am I missing something.

Granted a scripted date range find is a little tougher due to having to turn the date range into text to allow it to be put into the field for a find( But set field also works in this case but it's a calculated result that is input for the find). Is this what you are referring to?

Michael

Set Field does indeed work just fine, unless you require 'setting' a range, in which case an Insert Calculated Result step is necessary, because the result is not in date format as Set Field (on a date field) expects its results to be.

I personally use the // FM's date symbol for today, that way you are always ok when looking for today.