how to create a search date script?

[henrywid]

Hey,

I have created a find page with one of the fields being a date field. Now, whenever someone wants to find a record, they will be sent to this page whereby they can specify the date, name etc... now, what happens is that is a person wants to search for a range of dates, he will have to go to the date field and type MM/DD/YY...MM/DD/YY...

My next step now is to create 2 more date fields(DateFrom and DateTo). So when a person is going to search for a range of dates, he will just have to key in the 2 dates(from and to) into the respective fields and then click on the Search button to extract the range of dates.

Hopefully this is clear enough to explain my problems. Thanks.

[yafreax]

in the find script use the following:

Set Field [ Date, DateStart ]

insert calc. result [ Date, "

[henrywid]

Jeremy,

Thanks for the reply.

I tried the script, it doesn't seem to work. In troubleshooting, I actually, took out the Perform Find script, to see if it does actually inserted the datefrom, "..." and dateto into the date field. But in fact it didnot insert the range of dates into it. Any ideas?

Thanks again.

Henry

[signal]

How about:

Set Field [ Date, gDateStart & "..."& gDateEnd ]

I made the date entries globals

[LiveOak]

Unfortunately, the set field approach doesn't work. Yafreax has the correct approach. Maker sure: 1) the start and end data fields are global fields and 2) the Date field appears on the layout you are on when the script is run.

Enter Find Mode () <--- make sure restore is not checked

Set Field [ Date, gDateStart ]

Insert Text [ Date, "

[BobWeaver]

Also, make sure that you have the Date field formatted to "allow entry into field".