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

Translating Dates into a week of and a grouping header

P: 17
I need to be able to group date field by week. I can identify the week but I need to translate the ww into a date. For example; if the date falls in the 5th week of the year, I want to group all the dates that fall in week (jan 28 though the Jan 31) all together. Does anyone have work around solution or know what functions I could use in a query or report. I have done with using the Monthname function but can't find a similar function for week of. Thank you
Jul 10 '07 #1
Share this Question
Share on Google+
2 Replies

P: 97
Try this:
Expand|Select|Wrap|Line Numbers
  1. Week:[Your_date_field]-Weekday([Your_date_field],1)
Look up the help file for Weekday, to get the correct start day for your week.
Jul 10 '07 #2

P: 17
Thank you. It worked perfectly.
Jul 10 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.