Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

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

Posted

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?

  • 4 weeks later...
Posted

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.

This topic is 6589 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.