Date Range

[pingu1000]

Using a script to enter start and end date (both fields are date type) in a date field with the ... seperators in a find layout

Result is only the start date is enterd into the date field an nothing else

Can anyone help.

[LiveOak]

This is one of the goofy "features" of FM. To make this happen takes a few more steps. Lets assume the data range is defined by global dat fields "gDate1" and "gDate2". The date field to be searched is "Date". The script to do a range search is:

Enter Find Mode []

Insert Calculated Result [select,"Date", "gDate1"]

Insert Text ["Date","..."]

Insert Calculated Result ["Date","gDate2"]

Perform Find []

Make sure the Date field is visible on the layout you are using when you run the script. This is one case where the Set Field command does not help you. It is necessary to "build" the range to be searched in the Date field.

OBTW, if you are not in FM 5.0:

Insert Calculated Result --> Paste Result

Insert Text --> Paste Literal

Why the FM software team insists on changing the name of script steps to no obvious clarity advantage is a mystery to me -bd

[This message has been edited by LiveOak (edited November 17, 2000).]