SQL Query Date&Time

If you want to querying a time interval you can use;

Maurits,
it depends on what database you use.
What is your database and what error message you getting using this query?

Sorry i forgot to tell...i am using an MS Access Database.

It is for a Special offers database, so it will only show the offers between to dates in the database.
It comes up with an error: Undefined function 'getdate' in expression.
Is there another way to do this?

What happens when you use query with Now()?

I have tried it like you said but with error message:

MS Access driver: Syntax error (missing operator) in query expression 'Details.AvailDate => now() AND Details.CloseDate =< now()'
Here is the SQL:
SELECT

a

b

c

AvailDate

CloseDate

FROM Details

WHERE Details.AvailDate => now() AND Details.CloseDate =< now()
Is there something i am doing wrong?

When using MS Access you need to put # around your dates.
The following works in my application:
strSQL="select from spschedule where sDate=#" & rstmpDates("sDate") & "# AND S_IDNumber = " & SESSION("_spcalendar_OwnerID") & " ORDER BY scheduleID asc"
You may need to setup a variable equal to the Now() value first.
strDate1 = Now()

strDate2 = Now() + 3
strSQL = "SELECT FROM Details WHERE Details.AvailDate => #" & strDate1 & "# AND Details.CloseDate =< #" & strDate2 &"#"
Hope this helps!!
Carey

I have tried it like you said but with error message:

I have tried it like you said but with error message:

Try this below, see my additions and changes in BOLD:
SELECT

a

b

c

AvailDate

CloseDate

FROM Details

WHERE Details.AvailDate >= now()-1 AND Details.CloseDate <= now()-1