I am trying to retrieve access from a Pervasive Database using Pervasive ODBC. I want to find employees hired after a certain date. my current query looks like:
Employee.HireDate >= '01/01/2015'
I have also tried Employee.HireDate >= '20150101' In either case I get the error "Error : -1 [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Error in predicate: Employee . HireDate >= '01/01/2015' "
Can anyone help my identify the proper format/syntax of the where clause using a date?