Jump to content

Search by date with FX & FMSA8?


kfutter
 Share

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

Recommended Posts

I've come across a snag getting some newly converted files to work as previously with FX. I've got a calendar database that a couple of different pages query by date, but I'm now getting error 500 back from FileMaker ("Date value does not meet validation entry options"). The relevant part of the query string causing the problem looks like this:

[...] date.op=gte&date=20%2F12%2F2006&-find

As you can see, FM seems to be choking on the URL-encoded version of the date. It worked fine in v6, but v8 seems much more strict with things like this (which by itself is no bad thing).

Does anybody know how to get around this problem?

Cheers,

Kevin

Link to comment
Share on other sites

Apologies for replying to my own post, but it turns out that it isn't the URL encoding causing the problem after all. Rather, it was the fact that I was using dd/mm/yyyy format, rather than mm/dd/yyyy format. Having swapped it around, it now works perfectly. This is obviously another difference between v6 & v8 - anybody know if this is a setting that can be changed?

Link to comment
Share on other sites

  • 4 weeks later...

Replying to myself yet again :

It seems that our server may have been incorrectly set up with the wrong date system, which would explain the problem above. Still looking in to that one, but it appears not to be a FileMaker issue after all.

Link to comment
Share on other sites

This topic is 5742 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
 Share

×
×
  • Create New...

Important Information

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