Syntax Error

[vbjohn]

I am getting this error:

Syntax Error in date in query expression '((APHistory.POSTEDDT Between #01/01/2003# AND #11/31/2003#))'

Can anyone help me with this?


John-

 

[mission2java_78]

I am getting this error:

Syntax Error in date in query expression '((APHistory.POSTEDDT Between #01/01/2003# AND #11/31/2003#))'

Can anyone help me with this?


John-

Can you post a screen shot of the query? Or attach db?

I really cant tell with just that..is POSTEDDT a date?

Jon

 

[vbjohn]

Date/Time

 

[mission2java_78]

Date/Time

 

[jbg]

There are only 30 days in november - i think that would cause the error...

 

[mission2java_78]

There are only 30 days in november - i think that would cause the error...

 

[vbjohn]

Man do I feel stupid.... it works.. Sorry everyone..


john-