SQL Syntax for table select

Discussion created by aradford on Nov 18, 2013
Latest reply on Nov 18, 2013 by Wayne_Whitley
Hi i am trying to perform a table select on a file gdb table using the table select tool in python. It is a date field and i can get find the syntax error. I am sure it something simple. any suggestions are appreciated.

arcpy.TableSelect_analysis(table,nt,"date" >= 'date' '2012-01-02 00:00:00' and "date" <= 'date' '2012-01-04 00:00:00'