title: MS Access VBA on Dateadd's for current day
body: <p>I've got a question on the dateadd statement I'm using. The idea is that a form pops up with the day of the week and you can select it to add a due date. 
  IE: You select Monday and if it is Monday then it will give you a due day of Monday but if it's Tuesday then the following Monday will be used for your due date.</p>
  
  <p>The issue is that if it's Monday and you select Monday it is giving you the following Monday as a due date and not that current day.</p>
  
  <p>Here is the statement I'm using...</p>
  
  <pre><code> DateAdd('d',8-Weekday(Date(),4),Date())
  </code></pre>
  
  <p>I'm not sure how to make this correction since this seems correct to me. 
  Any help would be greatly appreciated.</p>