How to display date and time in UTC format i.e, 2018-05-02T13:47:33.743Z? | Community
Skip to main content
S
sonikad8559822
Level 2
October 23, 2018
Solved

How to display date and time in UTC format i.e, 2018-05-02T13:47:33.743Z?

  • October 23, 2018
  • 4 replies
  • 6366 views

Hi,

I have an Export workflow, that extracts data from tracking logs and recipient schema and is storing the data in a .csv file. I have a requirement that while extracting date-time data we should be displaying in file (example as 2018-05-02T13:47:33.743Z) this.

My campaign database is configured to store data in UTC format but I want the data while placing in file in the above mentioned format. How to achieve this? Currently I am getting data as: 10/23/2018  8:38:01 AM.

Thanks in Advance.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by DebTr

    Hi Sonika,

    This can be achieved using an "Export File" activity with help of calculated fields.

    New Calculated Field

    Code

    Output file

    4 replies

    S
    sonikad8559822Author
    Level 2
    October 23, 2018

    Vipul Raghav​, Adhiyan​ Can you please help in this?

    M
    Megmed1990
    October 23, 2018

    Hi there,

    I don't think you can do that in the export file activity.

    One way to do this would be to convert the date you want in a SQL activity just before the extract file activity.

    Do you happen to know which DBMS your Adobe instance is using ?

    Mohamed

    david--garcia
    david--garcia
    Level 10
    October 24, 2018

    You are referring to ISO 8601 time, The Z suffix in the ISO 8601 time representation is sometimes referred to as "Zulu time" because the same letter is used to designate the Zulu time zone.

    ISO 8601 - Wikipedia

    Should get the following.

    As for the extract, you need to use an expression with SQL, there are other ways, but this is the quickest I knew

    In the column expression use the following, where GetDate() can be replaced with your tsColumnName (name of your field with timestampt) and append the Z manually for (ZULU timezone otherwise known as UTC )

    [SQLDATA[CONVERT(VARCHAR(30), tsyourdatehere, 126)+'Z']]

    D
    DebTrAccepted solution
    Level 6
    October 24, 2018

    Hi Sonika,

    This can be achieved using an "Export File" activity with help of calculated fields.

    New Calculated Field

    Code

    Output file

      Terms & ConditionsAccessibility statement

      Loading footer...