AnsweredAssumed Answered

xml date format XSLT defined

Question asked by f.i.sciences on Sep 19, 2017
Latest reply on Sep 19, 2017 by beverly

I'm importing XML with XSLT template. All is fine except the date/time format in XML is :

<created>20170530T135219Z</created>

 

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

 

Thank you.

Outcomes