Using today's date in a query

[Guest]

I have a table that includes dates in a "DATE" field. How do I design a
query to pull records, where the date in the "DATE" field would equal today's
date? Thanks.

 

[Rick Brandt]

I have a table that includes dates in a "DATE" field. How do I
design a query to pull records, where the date in the "DATE" field
would equal today's date? Thanks.

First, change the name of the field to "RecordDate" or similar as "Date" is
a reserved word (name of a function). Then use...

SELECT *
FROM TableName
WHERE RecordDate = Date()

 

[Guest]

Thanks for your help and quick response.

First, change the name of the field to "RecordDate" or similar as "Date" is
a reserved word (name of a function). Then use...

SELECT *
FROM TableName
WHERE RecordDate = Date()