Export CSV File from more than a single query

I need to generate a csv file for my application, however the data needs some values formatted before it is written to the file.

Here is an example
field1,field2,field3.“2018-07-27 11:07:58”,field4

Above all the field1,2,3,4 entries are perfect as they are returned however for the date i need it formatted to YYYY-MM-DD only and the time needs to be removed. Is there a way within the query to format the returned data. Or is there a way to join multiple queries together in the Export Data step of the Export CSV File component, i have tried a number of ways bue most often it returns an error saying “Data is not an array.” so im not sure how to get around this unfortunately.

Community Page
Last updated: