since ‎09-08-2019
‎16-05-2020
henrikm69539229
Level 1
Re: How to display date and time in UTC format i.e, 2018-...
Avatar

henrikm69539229

henrikm69539229
- Adobe Campaign Standard

Views

645

Like

1

Replies

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

henrikm69539229

henrikm69539229
- Adobe Campaign Standard
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. In Classic i could do something like this: [SQLDATA[CONVERT(VARCHAR(30), tsyourdatehere, 126)+'Z']] But that is not possible in Standard. Thanks 🙂

Views

654

Likes

0

Replies

1
Likes given to
Likes from