inserting a date in a scripted search

[Howard Schlossberg]

Two possible issues to check:
1) You must use the Insert Calculated Result step, as this will not work
with Set Field.
2) The EventDate field must be on the layout at the time the Insert step
is used. I usually handle this with a freeze window, GoTo Layout[All
Fields], Insert, Goto Layout[Original Layout]

Claude Carlos wrote:

> I first select on the calendar the latest date of the events I want to
> search
> I then go to a layout in SEARCH mode
> I now want to find all the records before that date.
> I insert "<=selected date" in the event date field
> And finally execute the search.
>
> Seems logical but the script doesn't work...
> I can't get the" <=selected date" to be transfered to the event date field.
> When done " manually" it works but I can't get the script to work

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance

[Claude Carlos]

Thanks Howard
MY mistake, I had selected in the script the wrong field
on the layout to insert the calculated result...

Thanks again

Claude
"Howard Schlossberg" <howard@antispahm.fmprosolutions.com> a écrit dans le
message de news: [email]vg39todglnj992@corp.supernews.com[/email]...

> Two possible issues to check:
> 1) You must use the Insert Calculated Result step, as this will not work
> with Set Field.
> 2) The EventDate field must be on the layout at the time the Insert step
> is used. I usually handle this with a freeze window, GoTo Layout[All
> Fields], Insert, Goto Layout[Original Layout]
>
> Claude Carlos wrote:
>

> > I first select on the calendar the latest date of the events I want to
> > search
> > I then go to a layout in SEARCH mode
> > I now want to find all the records before that date.
> > I insert "<=selected date" in the event date field
> > And finally execute the search.
> >
> > Seems logical but the script doesn't work...
> > I can't get the" <=selected date" to be transfered to the event date

field.

> > When done " manually" it works but I can't get the script to work

>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Schlossberg (818) 883-2846
> FM Pro Solutions Los Angeles, California
> Associate Member, FileMaker Solutions Alliance
>