Need help with a date Querey 1

[cstringer]

Hello all,
I have a table called "Database". Each entry in this table has a "Date Opened" field and a "Date Closed" field. What I am attempting to accomplish is to run a querey against that table and find all records that are two days old or older as long as the "Date Closed" field is Null. I am sure this can be done with a simple querey, but since I am fairly new at this the answer eludes me.

Thanks,
Chuck

 

[jhall01]

in the criteria for the [date closed] put "IS NULL"

on the criteria for the [date opened] put " > DATE() - 2"

As long as your field format is a short date this should work.

 

[cstringer]

Thanks for the quick reply!
What if the Date Opened and Date Closed fields were created by a Calender control and stored in a text format? Should I go back and change it or is there another way?

 

[cstringer]

jhall01,

Thanks for the input. Your querey for some reason did not work but you did get me on the right track. I created 4 test records 3 of them were older than 2 days and 1 was not. The criteria that worked was [date opened] &quot; <Date()-2&quot;

Thanks!

 

[jhall01]

In the field name you might put some formating code to convert from text to Short Date.

IE ConDate: FORMAT([date opened],&quot;Short Date&quot

Which will format the data to a short date and then you can run the criteria. This is also good incase the data comes accross as 2 different formats...it will always convert it to a short date before it does the critera