Is the field you are searching on, a field of type date or a field of type text?
This method requires using a field of type date.
If that doesn't resolve the issue try posting the exact script that you have created.
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 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.
- 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. (Use the HTML option on the database tab panel and click "Source" in the Post A Answer tool bar to paste the text into the forum's HTML editor.)
I did not realize the field type was wrong! Thanks!!