Query Math With Dates

[businessman]

I want to have a query that will subtract a Due Date from todays date and tell me how many days are left/passed in either a positive number or negative just like the DateDiff Function. how do i do this?

 

[mhartman]

Hello:
Please enclosed example query. Run the qryDate query in the database
Regards
Mark

 

[businessman]

ok. that helped a ton. i can get the number of days difference like i want. now how come when i run a query to find where a field "Is Not Null" (its a date field), it will not find all of the records where this field has a date entered?

 

[RV]

ok. that helped a ton. i can get the number of days difference like i want. now how come when i run a query to find where a field "Is Not Null" (its a date field), it will not find all of the records where this field has a date entered?

I'd say that your query is not build according to your requirements

RV

 

[businessman]

the only other criteria is that another field says that it is an "Open" issue. all 4 of the dates that i have are open and yet it is only finding 3. what do you think could be wrong with the way i set up the query

 

[RV]

what do you think could be wrong with the way i set up the query

Well, that's 'bout the same as asking me what will be happening tomorrow, and I ain't got no crystal ball
You better post your query.

RV