date format in search

[BiknSwans]

I'm having a problem searching for all records with dates after a certain date. I enter FIND mode and then use Insert Calculated Result using the following:

">" & GetAsText(memberships::newsletter thank you date).

The text in the search field looks like this:

>2009/11/15

When the search starts, I get an error message:

The value of this field must be a valid date in the range of years 10 to 4000 and should look like "12/25/2003".

I use the exact same script step in another file on the same machine, and it works fine. In that case the search string looks like ">11/15/2009".

I've checked the file File/File Options/Text option, and tried both "Always use current system setting" and "Always use file's saved settings", but it makes no difference in either file.

How to I get Filemaker to insert the correct date format?

[comment]

Is memberships::newsletter thank you date a Date field? And is it in the same file as the table being searched?

[BiknSwans]

Yes, it is a date field (global) and it's in the same file. Oddly I used the same calculation in another script and table, but in the same file, and it works fine. I've played around with using different field formats in the layout, but it makes no difference.

[comment]

How does this field get populated? And what do you have selected under File > File Options… > Text > Data Entry?

[BiknSwans]

How does this field get populated? And what do you have selected under File > File Options… > Text > Data Entry?

The field that is being searched is filled in by a script with this step:

Max(Get(CurrentDate);memberships::newsletter labels date+1;memberships::newsletter thank you date+1)

The field that is being used to define the search is set by an Insert Calculated Result using this:

">" & GetAsText(memberships::newsletter thank you date)

The file option "Data Entry" that I used was "Always use current system setting". I also tried "Always use file's saved settings", but it made no difference.

[comment]

What you describe is very weird. Could you post a copy of your file? Please delete everything except the fields and the scripts you have mentioned.

[BiknSwans]

I gave up and decided to just use copy and paste to get the job done. When I did that, the correct date format was used.

I don't see any way to change the date format option in the file. I guess you can use its "saved settings", but I don't see a way to even view those. At any rate, I'm up and running again. In Filemaker there is always a way to make it happen.

Thanks for your time.