Date before today

[UT227]

I got my query to calculate a date. Now, I need it to only display [ExpDate] is that is equal to or before the current date. I've tried >=Date(), but get an error. Any ideas?

[ranman256]

LESS than:

<=Date()

[UT227]

I tried that. I get "Invalid use of null" error.

[ranman256]

filter out the nulls.

[UT227]

There are no nulls. When I run the query with the criteria blank, I get all fields filled. That was the first picture I posted. I can't figure out where any nulls are.

[ranman256]

this cannot be possible, if there are no nulls in the field, then you cannot get 'Invalid use of Nulls' error.
You are SURE ,that EVERY field has a date in it?
are there nulls in other fields?

if this is true, try compact/repair the db. It could be a false error.

[UT227]

I have this query based on a query. The first query filtered out all nulls. Using "=Date()" works. Using ">=Date()" works. For some reason "<=Date()" gives me that error.

[aytee111]

Post the SQL for the first query.

Post the SQL for the query that works (>=) and for the one that doesn't (<=).

The reason that >= works is that any date after today will be a real date and not contain a null. However, null is before today (in the sort sequence) and that is why you get the error. Run the first query without any criteria and sort ascending by the date field, that will show nulls at the top.

[UT227]

Thank you. That got me thinking about my calculations. I used CDATE to find a date. I took it out and just used the date. That eliminated the null. It works perfectly now.