If the filter module is returning the output as a date only, but the created_at field in your GraphQL schema expects a timestamptz can you correct this query

Queries and Resources
1

query purchaseOrderDetails($startTime: timestamptz, $endTime: timestamptz) {
purchaseOrder_purchaseOrder_aggregate(
where: { markedCompletedTime: { _is_null: false }, created_at: { _gte: $startTime, _lte: $endTime } }
) {
aggregate {
count
sum {
amount
}
}
}
}

2

Hi @Akshat_Kaushik Thanks for reaching out! You should be able to use moment().format(), a library that comes with Retool by default, to manipulate the date to the proper format :blush: