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;