Skip to main content
Question

Convert Date/Time stored as Double to an ISO Date

dilip
Contributor
Forum|alt.badge.img+2
  • dilipContributor
  • Contributor

Hi all,

For some reason an application is storing a date/time field as 'Double' - ''201805241214'' in this format, but the Date converter function does not recognise this as its a double field type, any help is greatly appreciated,

 

    2 replies

    ebygomm
    Influencer
    Forum|alt.badge.img+32
    • ebygommInfluencer
    • Influencer
    • August 7, 2018

    Are you providing the source date format? e.g. %Y%m%d%H%M

    david_r
    Celebrity
    • david_rCelebrity
    • August 7, 2018

    Agree with @egomm, you'll have to specify the source format.

    The issue is the timestamp is "missing" the seconds part, which is why I suspect FME don't automatically recognize it as a timestamp.

    Reply


    Helpful Members This Week

    Community Stats

    31,153
    Posts
    118,098
    Replies
    38,771
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.