Todays Date in SQL

Hi,
I am trying to build a rescordset where I select only items with todays date and todays date + 1

ie

SELECT *
From database
WHERE date = todays date

I have not been able to find (what is probably very right in front of me) the term for this..

Any suggestions and also links to a command reference?

Using Dreamweaver MX 2004, ASP and VBScript connecting to an MS Access Database

Cheers
Ken

Hi, Memnoch

I get a 'Data Type Mismatch in Criteria Expression' error
the Date Field in Access is set to Date/Time and Format is Medium Time

Does it have to be a specific format?

You input is greatly Appreciated...

Regards,
Ken

For Access

Hi,

This is how I finally got it working...

SELECT *FROM [Your_Table]
WHERE ((Your_Table.Date_Field)=Date());

SELECT *FROM [Your_Table]
WHERE ((Your_Table.Date_Field)=Date()+1);

Hope this helps others and thanks for your input..

Regards,
Ken

select * from table where convert(char,datefield,101) = convert(char,getdate(),101)

select * from table where convert(char,datefield,101) = convert(char,dateadd(day,1,getdate()),101)