You appear to have your script steps in incorrect order.
Try this variation:
Enter Find Mode 
Set Field [Quote Information::Date Quote Accepted ; Quote Information::GlobalStartDate & "..." & Quote Information::GlobalEndDate]
Perform Find 
Sort Records by Filed [Ascending; Quote Information::Date Quote Accepted]
Enter Preview Mode
For more examples of scripted finds, see: Scripted Find Examples
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post a New Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
thanks so much Phil - that has worked a treat.
To save me 3 hours of trawling through the internet would you mind telling me how can I get the date range to appear in the heading of my report?
Put the Quote Information::GlobalStartDate and Quote Information::GlobalEndDate fields in the header of your layout. You can use merge fields and merge text to put:
<<Quote Information::GlobalStartDate>>...<<Quote Information::GlobalEndDate>>
on your layout if you want to show the ... text. (and the above merge text can have a custom date format specified just like you would for any date field on your layout.)