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 :)
Printable View
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 :)
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