setting interval

[Francis]

Hello i'm trying to find out, how to make a query that outputs all the
records of GestaoTesouraria_Table, where the DataEmissao field is
between 21-04-2004 and 21-04-2005.

Sql i tryed in the first place was this:
SELECT *
FROM GestaoTesouraria_Table
WHERE GestaoTesouraria_Table.DataEmissao Between 21-04-2004 AND
21-04-2005;

but it doesnt seem to work properly, any help appreciated, thanks.

Francisco
(Portugal)

 

[Duane Hookom]

Access queries require date formats like m/d/yy. Consider checking out Allen
Browne's page http://www.allenbrowne.com/ser-36.html.

 

[Tom Ellison]

Dear Francis:

Yes, what Duane said!

So, use:

SELECT *
FROM GestaoTesouraria_Table
WHERE DataEmissao BETWEEN #04/21/2004#
AND #04/21/2005#;

Notice the placement of # around date literals.

Tom Ellison

 

[Francis]

Ok Thank you very much, it's working.

Francis
(Portugal)