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.

XML date format ignored

Featured Replies

Suppose I have a file set to use yyyy-mm-dd as the date format.

I export the records as XML (fmpxmlresult, no style sheet).

The resulting XML document contains:

...

...

2006-07-04

...

But when the document is imported into another file on another system, Filemaker ignores the declared date format, and imports the date data as invalid dates.

Actually, my REAL problem is importing from an external XML source, using a style sheet. The style sheet presents the XML data "as if" it came from another Filemaker file. The first example is only to show that the problem is not with the style sheet.

Eventually, I would like to distribute a Filemaker file that can import from the external XML source - no matter what any particular user's date format may be. So I cannot really tailor the style sheet to any specific format.

I could, of course, post-process the imported data in the FM file - but it seems awkward. Is there any way to get Filemaker to recognize the date format declared in the XML document?

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.