Follw up date 2

[Xzibit7]

I've got a query that returns values of items past a follow up date entered by a user with a calender in the query criteria I have <Date() so it should show all follow up dates past the current date. The problem is it does not return this it gives all dates entered even ones past the current date. Is using the calender causing this due to a different format in the date() function perhaps?

 

[Golom]

We probably need to see all of your query to figure out where the problem is.

Usually the date format has nothing to do with it unless you are comparing text string representations of the date instead of the date field values (which are actually numbers.)

 

[ThomasLafferty]

Hi Xzibit7!
Maybe I misread you, but when you use:

<Date() so it should show all follow up dates past the current date

In your criteria line for the date, you are using the less than symbol, so your query should return everything prior to today. My guess is you have a typo in your question ... As for the rest of your query, a quick thing to check is to make sure that your <Date() criteria is on the first line of the query design grid so that it is considered as a primary condition. If it is moved down one row, it will be evaluated as an OR instead of an AND. What this means, as I'm sure you know, is something like this:
Show all records meetings criteria OR all records prior to today's date.

Hope this helps.

Tom

Born once die twice; born twice die once.

 

[Xzibit7]

Tom yeah your right it should be a greater than..It is also in the criteria field..It strange now when I change it to greater that none of the dates show up (even the ones that are greater than) where as before all of the entered dates showed up. The table it is querying saves the date as text could this be the problem?

 

[Xzibit7]

Ok that was it...I changed the table to the date/time format. Thanks to both of you