I am trying to write a script to do the following:

Find all employee records with expiration dates (drivers license, car registration, car insurance, etc.) within the next month or so. I would like to make the expiration date a user defined input (can I use a dialog box for the user to input a date?). Then print a report that lists each employee's name with upcoming expirations and whichever fields and expiration dates meet the criteria.

I have experience w/ other programming and database design, but I'm really having a hard time with Filemaker (and the books I'm using don't have good examples to follow.) These forums have better information than the books, but I'm having difficulty putting it all together.

Thanks in advance for any assistance.

You will need to create a script to find records which have an expiration date between some beginning date (perhaps Get ( CurrentDate ) ) and some ending date (perhaps Get ( CurrentDate ) + 31. The report with the employees' names, upcoming expirations, etc. would then print for your found set. The design of the report would be up to you--it wouldn't necessarily have to resemble any of your input layouts.

Thanks for the help Transpower. It took two packages of Chocolate Hersheys Kisses and 2 six packs of diet coke (in 48 hours), but I got the dialog box and script written for the find operation. Can anyone point me in the right direction to only print those fields with upcoming expirations? I have 12-15 fields that have to be tracked with expiration dates for each employee and only want those applicable fields which are about to expire to print next to the employee name on my report. Any hints? Thanks much.