AnsweredAssumed Answered

How to determine the internal date format of a file

Question asked by BowdenData on Mar 6, 2013
Latest reply on Mar 6, 2013 by keywords

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.