Converting UTC Date to MM/DD/YYYY In query

Queries and Resources
1

I am trying to create a chart with the x-axis representative of single days, but as it currently stands, the axis is representative of UTC time. This is the current function I have for 'x-axis values': {{formatDataAsObject(query2.data.listOrders.items).createdAt}}

I am wondering what changes I can make, either within the query or in the 'x-axis values' field to convert createdAt from UTC time to the form MM/DD/YYYY.

Note: query2 below
query MyQuery {
listOrders {
items {
createdAt
totalPrice
}
}
}

2

Hi @MattyRob2, welcome :wave:
You can use momentJS:

solution1:
{{ moment(formatDataAsObject(query2.data.listOrders.items).createdAt).format('MM/DD/YYYY') }} //if createdAt is a single value

solution2:
{{ formatDataAsObject(query2.data.listOrders.items).createdAt.map(row => moment(row).format('MM/DD/YYYY') }} //if createdAt is a Array<datetime>