date query

hi

I have a query to find people with a birthday in the next week, the dates in the db are in the format DD/MM.
How do i get the current date in the same format so i can compare them.

Heres what i have >>>

SELECT client.Title, client.[First Name], client.Surname, client.Addressline1, client.Addressline2, client.Addressline3, client.County, client.Postcode, client_event.[event type], client_event.[event date]
FROM client INNER JOIN client_event ON client.Client_ID = client_event.[client id]
WHERE (((client_event.[event date]) Between Date() And Date()+"7"));

I can't see Date() + "7" working... you will need to use the dateadd() function. Surely you're storing people birthdays in the full date format, dd/mm/yyyy?