Query to return recently added records using system date

[hend]

Hi,



I have this query that I want to return all records entered from a date range i.e. 10/01/2008 to 01/01/2009. I thought the best way is to use the system date and use the Date() function. The sql is not returning any records as it is. Can someone help?

SELECT SPACE_habitable.SPACE, SPACE_habitable.FLOOR, SPACE_habitable.BUILDING
FROM SPACE_habitable
WHERE (Date() between '10/01/2008' and '01/31/2009')
ORDER BY Date() DESC;

[Ahmed Elalfy]

Dear Hend,

You can make a simple query and write in criteria of date field:
>=[Period from] And <=[To]

when will you run the query it will ask you period from? (insert the first date 1/1/2008)
and it will ask you again To? (insert the second date 31/12/2008)

Please try and feedback

Thanks

[hend]

Ahmed Elalfy
The code still does not return any records, Could there be something I'm not referencing? The code looks like this now:

SELECT SPACE_habitable.SPACE, SPACE_habitable.FLOOR, SPACE_habitable.BUILDING
FROM SPACE_habitable
WHERE (((Date())>=[Period From] And (Date())<=[To]))
ORDER BY Date() DESC;

[hend]

This is NOW returning the full recordset which is not what I want
The current code looks like this

SELECT SPACE_habitable.BUILDING, SPACE_habitable.SPACE, SPACE_habitable.FLOOR
FROM SPACE_habitable
WHERE (((Date()) Between (Date())>=[Period From] And [To]));

[Ahmed Elalfy]

Hend,
the function Date() is used to insert the current day date only ... you must add new field in your table to assign date for each record ... and after that you can make query to check records for limited period ...

Thanks