I'm tryinbg to do a scripted find for a date before today

so I paste "<" into the date field
and I do "insert today's date"

But although I have a script step for "set field" with "<", the "<" does
not end up in the date field

I guess because it is not a legal character for a field of type "date"

Any ideas how to do this ?

thanks

Two slashes (//) represent today's date in finds.

It's in the Symbols list, just above the Find button in Find Mode.

It's also in Help under "Finding Numbers, Dates and Times."

Matt



On 6/10/2005, Luke Siemaszko wrote:

I should clarify:

Your find should read "<//"

In 6 do that once, then script a find with Restor Find Requests.

I 7, you can just specify it in the Specify Find dialog.

Matt

On 6/10/2005, Luke Siemaszko wrote:

In article <Yvoqe.6730$K5.6714 (AT) newsfe4-win (DOT) ntli.net>, Luke Siemaszko
<no.spam.for.me (AT) please (DOT) com> wrote:

A quick test shows me that the "<" gets turned into a "?". So it looks
like you've found another in the list of "bugs" when it comes to using
Dates and Times with FileMaker's various field value setting script
commands. \

Change your script to use this command instead - it works properly.

Insert Calculated Result [DateField,
"<" & DateToText(Status(CurrentDate))]

You may or may not want the "Select entire contents" option turned on,
depending on what else you script is doing.

Note: 'Status(CurrentDate)' will need to be changed to
'Get(CurrentDate)' for FileMaker 7.




Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

In article <Yvoqe.6730$K5.6714 (AT) newsfe4-win (DOT) ntli.net>,
no.spam.for.me (AT) please (DOT) com says...
Don't use "set field", use "insert calculated result" instead.

42 wrote:

Thanks everyone for the replies - "Insert Calculated Result" is indeed
my friend. All working now.

Thanks

Luke