Support Topics Documentation Slack YouTube Blog

Invalid where clause iOS

I have a column name deliveryDate of type DATETIME.
When I query it using where clause, an error is returned saying that my where cause is invalid.
Here is my code

let dateFormatter = DateFormatter()
dateFormatter.dateFormat = “MM/dd/yyyy HH:mm:ss”
let dateString = dateFormatter.string(from:NSDate() as Date)
let queryBuilder = DataQueryBuilder()
queryBuilder.setPageSize(pageSize: 100)
queryBuilder.setWhereClause(whereClause: String(format: “deliveryDate >= %@”, dateString))

With the above query I receive the following error

Error Domain=BackendlessErrorDomain Code=1017 “Where clause ‘deliveryDate >= 08/05/2020 03:23:22’ is invalid” UserInfo={NSLocalizedDescription=Where clause ‘deliveryDate >= 08/05/2020 03:23:22’ is invalid}

Can anyone tell me how can I do it right?

Hi.
Have you tried that where clause but just in web-console for desired table?