Date field question...

[RIM-Pro]

Good evening all,

I have an Activity Date field in a query and was wondering how to show all activities that happened both on and after that date?

In the Activity Date field of the query grid, I’ve typed in [Enter Date] in the criteria cell.

So, for example if I wanted to know everything that happened from November 14th through the current date, I’d run the query and enter >=11/14/2005. However, when trying to run my query I get an error message that says "the expression is typed incorrectly or is too complex to be evaluated."

If I entered 11/14/2005 (without the greater than or equal signs), then the query runs but I only get the activities that happened on that particular day.

I don’t understand why the >=11/14/2005 doesn’t work, because when I put that same expression directly into the criteria cell of the Activity Date field in my query, I get the results I’m looking for.

Can anyone help?

Thanks.
Earl

 

[Jon K]

Try declaring the data type of the parameter.

In query Design View, choose menu Query, Parameters...
In the window that pops up, type the parameter [Enter Date] and select the data type.
.

 

[RIM-Pro]

Thanks for your response Jon K, but it didn't work. I followed your suggestions but now get an error message that says "The value you entered isn't valid for this field."

Any other help would be greatly appreciated.

Thanks.
Earl