Using convert and getdate functions

[RevelationUK]

Im trying to make a query , heres what I have so far: (the Date in my access database is in the format "dd/mm/yyyy")

SELECT *
FROM tblCustomers
WHERE (tblCustomers.State='No Letters Sent')
And (tblCustomers.DateEntered='29/06/2005');

however I get type mis match, now I believe I have to use the convert function maybe to change the date type? Secondly, I want to return the records where tblCustomers.DateEntered = TodaysDate. How do I do that?

SELECT *
FROM tblCustomers
WHERE (tblCustomers.DateEntered = Convert(something,getdate(),103)


maybe? Im guessing? thanks in advance, rev.

 

[PHV]

You may try simply this:
tblCustomers.DateEntered = Date

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dhookom]

Access queries use U.S. formatted dates
SELECT *
FROM tblCustomers
WHERE (tblCustomers.State='No Letters Sent')
And (tblCustomers.DateEntered=#06/29/2005#);

To refer to today, use Date(). When using Date() in a module, the ()s are removed.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]