I'm importing XML with XSLT template. All is fine except the date/time format in XML is :
Can't find what to use in DATEFORMAT and TIMEFORMAT definition.
<DATABASE DATEFORMAT="yyyymmdd" LAYOUT="" NAME="" RECORDS="1" TIMEFORMAT="kkmmss"/>
Should my FMP field be set to Date, Time or TimeStamp?
I keep getting value as text: 20170530T135219Z in my FMP field