Find records between two dates

[manj]

I have a query. I wish to select records that are between the current date and 1 month prior to the current date. How do I achieve this?

select col1, col2
from table
where date between currentdate and 1 month before current date

Any help will be appreciated.
[sig][/sig]

 

[THoey]

In Oracle:

SELECT col1, col2
FROM table
WHERE datefield > ADD_MONTHS(SYSDATE, -1) AND
      datefield < SYSDATE

Hope this helps...
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]

 

[manj]

Thanks Terry for the information,

I know sysdate retrieves the current date in Oracle but what about MS Access

Regards
manj [sig][/sig]

 

[THoey]

In Access, use the DATE function. Check it out in the help.

BTW, if you do not already subscribe to it, there is at least one Access specific newsgroup here.

Take Care,
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]