Regular expression or Data Formatting/Transformation with C80 for Date type

Home Forums Convertigo developers Forums as moved to Stack Overflow. Regular expression or Data Formatting/Transformation with C80 for Date type

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #134304

    RItesh K
    Participant

    Hi All

    Currently i am getting XML response as below, in which it is showing Date with Time Zone format.
    How can i change the Display to YYYY-MM-DD in Mobile UI

    I tried using Transformation and Data Element but no output

    <CreationDate>2014-09-16T16:56:29.382Z</CreationDate>

    Thanks

    #134312

    Gregory Vorbe
    Moderator

    Hello Ritesh,

    To accomplish this, use the Date/Time step:
    _ Set the Sources property adding just one new source pointing to your CreationDate/text() element.
    _ Then change, Source(s) format property to yyyy-MM-dd’T’HH:mm:ss.SSS’Z’
    _ Finally set, Format property to yyyy-MM-dd

    <document>
        <CreationDate>2014-09-16T16:56:29.382Z</CreationDate>
        <element>2014-09-16</element>
    </document>

    Support&QA

    #134315

    RItesh K
    Participant

    Hello Gregorgy

    Thanks a lot for this. Its working well

    Regards
    Ritesh

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.