Unanswered: Cannot set criteria on date field due to syntax
Hello, I am running into an issue where I cannot set criteria on a date field. It seems to recognize the field as a date field in table properties (and I can format it to mm/dd/yy in the query view) but when I set criteria to something like >=#6/30/2011# I get the following error:
[IBM][CLI Driver][DB2/6000]SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007"
Does anyone have any ideas how to remedy this? I am able to convert it to a text string and then set criteria on the string but that obviously takes a lot longer to run. Thanks!