title: Select a random day from last week in Access SQL
body: <p>I am attempting to build a query in Access that goes like this:</p>
  
  <pre><code>SELECT * 
  FROM my_table
  WHERE date_column BETWEEN X AND Y
  </code></pre>
  
  <p>Where I want X to be a random day of last week at 6am and Y the following day at 6am.</p>
  
  <p>I know i can do:</p>
  
  <pre><code>WHERE date_column Between DateAdd('ww',DateDiff('ww',7,Date()),0)-6 And DateAdd('ww',DateDiff('ww',7,Date()),6)-6))
  </code></pre>
  
  <p>To get all last week of data, but how do I do it just for a random day last week?</p>
  
  <p>Thanks!</p>