SQL Between Two Dates

[Razoe]

Heyz, i kind of need help with an SQL statement...

In the Table "Invite", there is a Field Called "Invite_Date"

and we suppose to create an SQL query to show all the invitations between 2 dates of our choosing...can anyone help me in writing this SQL?

I know im suppose to use the "Between" statement, but it doesnt seem to be working for me, i know im doing something wrong, but i just dont know what....here is what i tried...


SELECT Members.*, Invite.Invite_Date
FROM Members
WHERE Invite.Invite_Date >= ('2011/04/01', 'yyyy/mm/dd')
AND Invite.Invite_Date <= ('2011/04/30','yyyy/mm/dd');

 

[PHV]

How are joined Members and Invite ?
Anyway, see the JetSQL syntax below:
WHERE Invite.Invite_Date BETWEEN #2011-04-01# And #2011-04-30#

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886