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

Avatar

Avatar

sonikad8559822

Avatar

sonikad8559822

sonikad8559822

23-10-2018

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Deb121

Avatar

Deb121

Deb121

24-10-2018

Hi Sonika,

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

1605799_pastedImage_2.png

New Calculated Field

1605797_pastedImage_0.png

Code

1605798_pastedImage_1.png

Output file

1605800_pastedImage_3.png

Answers (3)

Answers (3)

Avatar

Avatar

david_garcia1

MVP

Avatar

david_garcia1

MVP

david_garcia1
MVP

24-10-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']]

1605732_pastedImage_0.png

Avatar

Avatar

Megmed1990

Avatar

Megmed1990

Megmed1990

23-10-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

Avatar

Avatar

sonikad8559822

Avatar

sonikad8559822

sonikad8559822

23-10-2018

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