<div>
This is perfect to me, thanks very much
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I need to calculate weeks in Access from date following such logic<br />
<br />
- if the date is smaller than today --&gt; week0<br />
- if the date is this week --&gt; week0<br />
- if the date is next week --&gt; week1<br />
- if the date is after next week --&gt; week2<br />
<br />
Basically the actual week is from monday to sunday, so as today is 2011-05-13 that is 6 by this formula - TodayWeekday: Weekday(Date()). This can have importance that the next week always starts at Monday so when the TodayWeekday is 2.<br />
<br />
thanks, 
</div>
</div>


Dear Experts,

I need to calculate weeks in Access from date following such logic

- if the date is smaller than today --> week0
- if the date is this week --> week0
- if the date is next week --> week1
- if the date is after next week --> week2

Basically the actual week is from monday to sunday, so as today is 2011-05-13 that is 6 by this formula - TodayWeekday: Weekday(Date()). This can have importance that the next week always starts at Monday so when the TodayWeekday is 2.

thanks, 

Access 2000 - Custom week calculation

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.