Week Number from Short Date format

E

Extra Tomato

Hi all please help this newbie !

I have built a simple dbase in Access 97 that captures overtime records
against a date field which is in dd/mm/yy format.

What I would like to do is build a query that lets the user enter a
weeknumber eg 06 which would then extract all records between the
2/2/04 to 8/2/04 inc.


Could anybody advise a way of doing this, I have tried several fix's
including DATEPART and FORMAT although I may have made syntax errors.

Thanks for your time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stumped By Dates 4
Vba Date$ 1
Week starts on Friday 3
date and time difference 19
Datepicker issue after changing Windows' short date time format 5
Date in the query is always short date 5
Default date format (with shortcut keys) 2
Display billing month based on start date and end date 5

Top