Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.
Juggernaut

Search by date with FX & FMSA8?

Featured Replies

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

  • Author

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...
  • Author

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.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.