Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4776 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

Posted

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

Posted

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?

Posted

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

Posted

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

Posted

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.

  • Like 1
Posted

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

This topic is 4776 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.