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?