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.
Solved! Go to Solution.