Date query on File GDB

[KevinBell]

I'm getting aggravating results trying to query a date time field in a fgdb...

If I use this:

"gpstime" > date '2011-06-14 10:00:00' AND "gpstime" < date '2011-06-14 11:00:00'

in the select by attributes dialog in arcmap it works fine, but using it as the whereclause in
arcpy.SelectLayerByAttribute i get the wrong times. 

ideas?

[KevinYanuk]

I'm getting aggravating results trying to query a date time field in a fgdb...

If I use this:

"gpstime" > date '2011-06-14 10:00:00' AND "gpstime" < date '2011-06-14 11:00:00'

in the select by attributes dialog in arcmap it works fine, but using it as the whereclause in
arcpy.SelectLayerByAttribute i get the wrong times. 

ideas?

There might be an issue with the quotations.  You could try to set it as a string variable, and passing the variable as the query:

query = "\"gpstime\" > date '2011-06-14 10:00:00' AND \"gpstime\" < date '2011-06-14 11:00:00'"

arcpy.SelectLayerByAttributes_management(lyr, "NEW_SELECTION", query)

edit:  notice the slashes I used in the query string to ignore ending the full string

[KevinBell]

I am actually passing it in as a variable.  I build the string up programmatically and print the whereclause using addMessage and this is how it prints out, which works if using the query builder.

[KevinBell · Accepted solution]

User Error!  I shouldn't program on Friday afternoons!  I just had a problem buried in the routine that builds the query.