Select to view content in your preferred language

Running a Date script in Select by Attributes

1132
0
03-21-2013 11:57 AM
Labels (1)
RhondaFarris
Deactivated User
Having some issues running a script.  I'm in Select by Attributes.  I have a table that has a "SaleDate" field.  I am trying to search the table by a "SaleDate". 

This is my script:

"SaleDate" = date '6/3/2008'

I choose Verify and it says, "the expression was verified successfully, but no records were returned"

I know this is incorrect because I have a field with that date in it.  Please help.  This simple project is blowing my mind!!!
0 Kudos
0 Replies