Find mode date error

[HHMacGuffin]

Hi,

I have encountered problem with he Start Date and End Date fields of my Events database in Find Mode.

Whenever I entered a date in Find Mode, say 1/11/2011, it automatically changes it to:

*/01/2011

*/11/2011

*/*/2011

The same thing happens if I use the Drop Down Calendar to choose my date.

I could not figure out what went wrong and would appreciate your help immensely, many thanks!

MacGuffin

[bcooney]

Are you the developer? Sounds like a script trigger is running, and converting your criterial to wildcard searches.

[HHMacGuffin]

Hi bcooney,

Thanks for moving the thread to the appropriate section, and yes I am the developer. The two fields are set up with conditional formatting that changes the fill colour, but apart from that I don't think I have set up any script triggers that changes dates like this.

In fact I just realised the dates in all my other tables are having the same problem...

MacGuffin

[bcooney]

So, you use the same layout for Browse and Find?

If you create a new layout, table view, and include your Start Date and End Date fields, what do you see? These fields are date fields (and not calcs), correct? How is the data populated?

[HHMacGuffin]

I use table view by default, and the dates are shown correctly (01/11/2011) in Browse mode.

The data are in date fields yes. The dates are imported from an Excel spreadsheet, which is also formatted as dates, and imported records are displayed correctly in Browse mode. I have tried creating new records and picked some random dates via the drop down calendar and that worked fine too.

It seems the problem only occurs in Find mode.

MacGuffin

[bcooney]

Can you post a file with some records so I can see this? (You need to zip it to upload).

[HHMacGuffin]

The file is attached, thanks

Sample.zip

[comment]

Wow - this is really a weird one. I think what went "wrong" here is that the file was created on a system whose short date format is "dd mm yyyy". Apparently, having a space as the separator utterly confuses Filemaker in Find mode - even if the file is set to use current system's settings.

I believe you must clone the file (after setting your system's short date format to "dd/mm/yyyy" or "dd-mm-yyyy" or similar), then import the data into the clone.

[HHMacGuffin]

The clone works! Many thanks!

Our computers here have recently been upgraded to Windows 7, so I guess that's the culprit.

Again a million thanks for your help.

MacGuffin

[bcooney]

That was an interesting one. Quite the catch there, Comment.