I am looking for a way to determine the internal, fixed date formatting of a FMP file, i.e., mm/dd/yyyy or dd/mm/yyyy, and so forth. I am aware of how the format gets set for a new/cloned/recovered file.
I could have sworn that the DDR XML data contained this information, but I am not seeing it now. This is using FMP11. I found one article at
but their example of using in a case statement has me baffled. I loaded up the doSQL plugin and copied the exact formula they suggest, but it gives me an error from the plugin.