By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Formatting Dates

P: n/a
I know how to fromat dates by weeks, as in Format([Date],"ww").
However, this displays the week as a number, such as 1, 2, 3, 4, to
represent 1st week, 2nd week etc of the year.
I am wondering if there is a function in Access that will display the
actual dates of each week in the year. For instance, I want to display
Jan 1-7 (as week 1), Jan 8-15 (as week 2) etc. Is this possible in
Access?
Marcus
******

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Possible, sure. As easy as a straight format, no way. You can do it
with date manipulation functions pretty easily. So what's your end
goal? Just a list of weeks?
1. Get the first day of the year
2. Add six days to that to get the last day of that first week (use
DateAdd).
3. Write those somewhere (a table sounds like a fun place).

4. Add a week to the result in 1.
5. Repeat steps 2 and 3 until you've done all the dates you want. (I
sense a do loop in there...)
Why exactly did you need this? There may well be an easier answer to
your question. But I can't tell from the information provided.

Nov 13 '05 #2

P: n/a
I'm looking to do something like this in my query:

Start Week---Total Courses Starting---Courses Starting by Subjects

Aug 16-31---2-----ESL-----------------------------1
-------------------------Professional Studies-----1
Sept 1-2------51---ESL-----------------------------5
-------------------------Professional Studies-----9
-------------------------Languages-------------------37
Sept 2-11----18---ESL-----------------------------1
-------------------------Professional Studies-----10
-------------------------Languages-------------------7

Marcus
********

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.