How to Properly Construct a WHERE Clause with Date Filtering in getinvoices (C#) #597
Description
Description:
I’m trying to filter a list of invoices using a WHERE clause that includes a date condition. I’m encountering a type mismatch error when comparing a DateTime? field (DueDate) with a string representation of a date.
"Message": "Operator '>' incompatible with operand types 'DateTime?' and 'String'"
// Incorrect approach causing the error
var where = "Type=="ACCPAY" AND DueDate > "2024-01-01" ";
// Assume getinvoices() is a method/property that uses this "where" clause
// e.g. getinvoices(where);