Find Dates in the same week

[qwertyman]

How do I write a procedure that find all the dates in a field from a table in a Access database that are the same week as today's date, or a selected date. Format is dd/mm/yy.
Please help, Thanks a million

[_bman_]

i am no vb expert and i'm sure that there is an easier way to do this.

'compare return values of
'ww = week of year
datepart("ww", now) = datepart("ww", entry in database)

'you may also want to compare the year
datepart("yyyy", now) = datepart("yyyy", entry in database)

again, i am no expert but i hope this helps